<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DsTempList" targetNamespace="http://tempuri.org/DsTempList.xsd" xmlns:mstns="http://tempuri.org/DsTempList.xsd" xmlns="http://tempuri.org/DsTempList.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="DocumentsQueryAdapter" GeneratorFunctionsComponentClassName="DocumentsQueryAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="DocumentsQueryAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="DIGI_DOCConnectionString" IsAppSettingsProperty="True" Modifier="Assembly" Name="DIGI_DOCConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.VirtualDesk.My.MySettings.GlobalReference.Default.DIGI_DOCConnectionString" Provider="System.Data.SqlClient">
          </Connection>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="db_VirtualDeskConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="db_VirtualDeskConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.VirtualDesk.My.MySettings.GlobalReference.Default.db_VirtualDeskConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TBL_DOCTableAdapter" GeneratorDataComponentClassName="TBL_DOCTableAdapter" Name="TBL_DOC" UserDataComponentName="TBL_DOCTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_DOC" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [TBL_DOC] WHERE (([DOC_ID] = @Original_DOC_ID) AND ([DOC_CAT_ID] = @Original_DOC_CAT_ID) AND ([DOC_SUB_CAT_ID] = @Original_DOC_SUB_CAT_ID) AND ([DOC_TYPE] = @Original_DOC_TYPE) AND ([DOC_DATE] = @Original_DOC_DATE) AND ([DOC_VERSION] = @Original_DOC_VERSION) AND ([DOC_NAME] = @Original_DOC_NAME) AND ([DOC_EXT] = @Original_DOC_EXT) AND ([DOC_AUTHOR] = @Original_DOC_AUTHOR) AND ([DOC_SUBJECT] = @Original_DOC_SUBJECT) AND ([DOC_KEYWORDS] = @Original_DOC_KEYWORDS) AND ((@IsNull_DOC_INUSE = 1 AND [DOC_INUSE] IS NULL) OR ([DOC_INUSE] = @Original_DOC_INUSE)) AND ((@IsNull_DOC_USERID = 1 AND [DOC_USERID] IS NULL) OR ([DOC_USERID] = @Original_DOC_USERID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DOC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DOC_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DOC_SUB_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_SUB_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DOC_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_TYPE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DOC_DATE" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DOC_DATE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DOC_VERSION" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="DOC_VERSION" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DOC_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_NAME" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DOC_EXT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_EXT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DOC_AUTHOR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_AUTHOR" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DOC_SUBJECT" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DOC_SUBJECT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DOC_KEYWORDS" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_KEYWORDS" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DOC_INUSE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_INUSE" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_DOC_INUSE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DOC_INUSE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DOC_USERID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_USERID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DOC_USERID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_USERID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [TBL_DOC] ([DOC_CAT_ID], [DOC_SUB_CAT_ID], [DOC], [DOC_TYPE], [DOC_DATE], [DOC_VERSION], [DOC_NAME], [DOC_EXT], [DOC_AUTHOR], [DOC_SUBJECT], [DOC_KEYWORDS], [DOC_TEXT], [DOC_INUSE], [DOC_USERID]) VALUES (@DOC_CAT_ID, @DOC_SUB_CAT_ID, @DOC, @DOC_TYPE, @DOC_DATE, @DOC_VERSION, @DOC_NAME, @DOC_EXT, @DOC_AUTHOR, @DOC_SUBJECT, @DOC_KEYWORDS, @DOC_TEXT, @DOC_INUSE, @DOC_USERID);
SELECT DOC_ID, DOC_CAT_ID, DOC_SUB_CAT_ID, DOC, DOC_TYPE, DOC_DATE, DOC_VERSION, DOC_NAME, DOC_EXT, DOC_AUTHOR, DOC_SUBJECT, DOC_KEYWORDS, DOC_TEXT, DOC_INUSE, DOC_USERID FROM TBL_DOC WHERE (DOC_ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DOC_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DOC_SUB_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_SUB_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@DOC" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="DOC" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOC_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_TYPE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DOC_DATE" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DOC_DATE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DOC_VERSION" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="DOC_VERSION" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOC_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_NAME" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOC_EXT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_EXT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOC_AUTHOR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_AUTHOR" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DOC_SUBJECT" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DOC_SUBJECT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOC_KEYWORDS" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_KEYWORDS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOC_TEXT" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="DOC_TEXT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@DOC_INUSE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DOC_INUSE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DOC_USERID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_USERID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     DOC_ID, DOC_CAT_ID, DOC_SUB_CAT_ID, DOC, DOC_TYPE, DOC_DATE, DOC_VERSION, DOC_NAME, DOC_EXT, DOC_AUTHOR, DOC_SUBJECT, 
                      DOC_KEYWORDS, DOC_TEXT, DOC_INUSE, DOC_USERID
FROM         TBL_DOC</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [TBL_DOC] SET [DOC_CAT_ID] = @DOC_CAT_ID, [DOC_SUB_CAT_ID] = @DOC_SUB_CAT_ID, [DOC] = @DOC, [DOC_TYPE] = @DOC_TYPE, [DOC_DATE] = @DOC_DATE, [DOC_VERSION] = @DOC_VERSION, [DOC_NAME] = @DOC_NAME, [DOC_EXT] = @DOC_EXT, [DOC_AUTHOR] = @DOC_AUTHOR, [DOC_SUBJECT] = @DOC_SUBJECT, [DOC_KEYWORDS] = @DOC_KEYWORDS, [DOC_TEXT] = @DOC_TEXT, [DOC_INUSE] = @DOC_INUSE, [DOC_USERID] = @DOC_USERID WHERE (([DOC_ID] = @Original_DOC_ID) AND ([DOC_CAT_ID] = @Original_DOC_CAT_ID) AND ([DOC_SUB_CAT_ID] = @Original_DOC_SUB_CAT_ID) AND ([DOC_TYPE] = @Original_DOC_TYPE) AND ([DOC_DATE] = @Original_DOC_DATE) AND ([DOC_VERSION] = @Original_DOC_VERSION) AND ([DOC_NAME] = @Original_DOC_NAME) AND ([DOC_EXT] = @Original_DOC_EXT) AND ([DOC_AUTHOR] = @Original_DOC_AUTHOR) AND ([DOC_SUBJECT] = @Original_DOC_SUBJECT) AND ([DOC_KEYWORDS] = @Original_DOC_KEYWORDS) AND ((@IsNull_DOC_INUSE = 1 AND [DOC_INUSE] IS NULL) OR ([DOC_INUSE] = @Original_DOC_INUSE)) AND ((@IsNull_DOC_USERID = 1 AND [DOC_USERID] IS NULL) OR ([DOC_USERID] = @Original_DOC_USERID)));
SELECT DOC_ID, DOC_CAT_ID, DOC_SUB_CAT_ID, DOC, DOC_TYPE, DOC_DATE, DOC_VERSION, DOC_NAME, DOC_EXT, DOC_AUTHOR, DOC_SUBJECT, DOC_KEYWORDS, DOC_TEXT, DOC_INUSE, DOC_USERID FROM TBL_DOC WHERE (DOC_ID = @DOC_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DOC_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DOC_SUB_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_SUB_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@DOC" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="DOC" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOC_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_TYPE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DOC_DATE" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DOC_DATE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DOC_VERSION" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="DOC_VERSION" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOC_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_NAME" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOC_EXT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_EXT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOC_AUTHOR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_AUTHOR" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DOC_SUBJECT" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DOC_SUBJECT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOC_KEYWORDS" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_KEYWORDS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOC_TEXT" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="DOC_TEXT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@DOC_INUSE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DOC_INUSE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DOC_USERID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_USERID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DOC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DOC_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DOC_SUB_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_SUB_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DOC_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_TYPE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DOC_DATE" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DOC_DATE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DOC_VERSION" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="DOC_VERSION" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DOC_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_NAME" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DOC_EXT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_EXT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DOC_AUTHOR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_AUTHOR" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DOC_SUBJECT" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DOC_SUBJECT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DOC_KEYWORDS" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_KEYWORDS" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DOC_INUSE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_INUSE" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_DOC_INUSE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DOC_INUSE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DOC_USERID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_USERID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DOC_USERID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_USERID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="DOC_ID" ColumnName="DOC_ID" DataSourceName="DIGI_DOC.dbo.TBL_DOC" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DOC_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DOC_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DOC_ID" DataSetColumn="DOC_ID" />
              <Mapping SourceColumn="DOC_CAT_ID" DataSetColumn="DOC_CAT_ID" />
              <Mapping SourceColumn="DOC_SUB_CAT_ID" DataSetColumn="DOC_SUB_CAT_ID" />
              <Mapping SourceColumn="DOC" DataSetColumn="DOC" />
              <Mapping SourceColumn="DOC_TYPE" DataSetColumn="DOC_TYPE" />
              <Mapping SourceColumn="DOC_DATE" DataSetColumn="DOC_DATE" />
              <Mapping SourceColumn="DOC_VERSION" DataSetColumn="DOC_VERSION" />
              <Mapping SourceColumn="DOC_NAME" DataSetColumn="DOC_NAME" />
              <Mapping SourceColumn="DOC_EXT" DataSetColumn="DOC_EXT" />
              <Mapping SourceColumn="DOC_AUTHOR" DataSetColumn="DOC_AUTHOR" />
              <Mapping SourceColumn="DOC_SUBJECT" DataSetColumn="DOC_SUBJECT" />
              <Mapping SourceColumn="DOC_KEYWORDS" DataSetColumn="DOC_KEYWORDS" />
              <Mapping SourceColumn="DOC_TEXT" DataSetColumn="DOC_TEXT" />
              <Mapping SourceColumn="DOC_INUSE" DataSetColumn="DOC_INUSE" />
              <Mapping SourceColumn="DOC_USERID" DataSetColumn="DOC_USERID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByCategories" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByCategories" GeneratorSourceName="FillByCategories" GetMethodModifier="Public" GetMethodName="GetDataByCategories" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByCategories" UserSourceName="FillByCategories">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     TBL_DOC.DOC_ID, TBL_DOC.DOC_CAT_ID, TBL_DOC.DOC_SUB_CAT_ID, TBL_DOC.DOC, TBL_DOC.DOC_TYPE, TBL_DOC.DOC_DATE, 
                      TBL_DOC.DOC_VERSION, TBL_DOC.DOC_NAME, TBL_DOC.DOC_EXT, TBL_DOC.DOC_AUTHOR, TBL_DOC.DOC_SUBJECT, 
                      TBL_DOC.DOC_KEYWORDS, TBL_DOC.DOC_TEXT, TBL_DOC_CAT.DOC_CAT_TYPE, TBL_DOC_SUB_CAT.DOC_SUB_CAT_TYPE, 
                      TBL_DOC.DOC_INUSE, TBL_DOC.DOC_USERID
FROM         TBL_DOC INNER JOIN
                      TBL_DOC_CAT ON TBL_DOC.DOC_CAT_ID = TBL_DOC_CAT.DOC_CAT_ID INNER JOIN
                      TBL_DOC_SUB_CAT ON TBL_DOC.DOC_SUB_CAT_ID = TBL_DOC_SUB_CAT.DOC_SUB_CAT_ID AND 
                      TBL_DOC_CAT.DOC_CAT_ID = TBL_DOC_SUB_CAT.DOC_CAT_ID</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_DOC" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByDOC_ID" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByDOC_ID" GeneratorSourceName="FillByDOC_ID" GetMethodModifier="Public" GetMethodName="GetDataByDOC_ID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByDOC_ID" UserSourceName="FillByDOC_ID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT DOC, DOC_AUTHOR, DOC_CAT_ID, DOC_DATE, DOC_EXT, DOC_ID, DOC_INUSE, DOC_KEYWORDS, DOC_NAME, DOC_SUBJECT, DOC_SUB_CAT_ID, DOC_TEXT, DOC_TYPE, DOC_USERID, DOC_VERSION FROM TBL_DOC WHERE (DOC_ID = @DOC_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="DOC_ID" ColumnName="DOC_ID" DataSourceName="DIGI_DOC.dbo.TBL_DOC" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DOC_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DOC_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TBL_DOC_COMMENTTableAdapter" GeneratorDataComponentClassName="TBL_DOC_COMMENTTableAdapter" Name="TBL_DOC_COMMENT" UserDataComponentName="TBL_DOC_COMMENTTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_DOC_COMMENT" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[TBL_DOC_COMMENT] WHERE (([COMMENT_ID] = @Original_COMMENT_ID) AND ([COMMENT_DOC_ID] = @Original_COMMENT_DOC_ID) AND ([COMMENT_TITLE] = @Original_COMMENT_TITLE) AND ([COMMENT_DATE] = @Original_COMMENT_DATE))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_COMMENT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COMMENT_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_COMMENT_DOC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COMMENT_DOC_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COMMENT_TITLE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COMMENT_TITLE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_COMMENT_DATE" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="COMMENT_DATE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[TBL_DOC_COMMENT] ([COMMENT_DOC_ID], [COMMENT_TITLE], [COMMENT_DESC], [COMMENT_DATE]) VALUES (@COMMENT_DOC_ID, @COMMENT_TITLE, @COMMENT_DESC, @COMMENT_DATE);
SELECT COMMENT_ID, COMMENT_DOC_ID, COMMENT_TITLE, COMMENT_DESC, COMMENT_DATE FROM TBL_DOC_COMMENT WHERE (COMMENT_ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@COMMENT_DOC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COMMENT_DOC_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COMMENT_TITLE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COMMENT_TITLE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COMMENT_DESC" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="COMMENT_DESC" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@COMMENT_DATE" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="COMMENT_DATE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT COMMENT_ID, COMMENT_DOC_ID, COMMENT_TITLE, COMMENT_DESC, COMMENT_DATE FROM dbo.TBL_DOC_COMMENT</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[TBL_DOC_COMMENT] SET [COMMENT_DOC_ID] = @COMMENT_DOC_ID, [COMMENT_TITLE] = @COMMENT_TITLE, [COMMENT_DESC] = @COMMENT_DESC, [COMMENT_DATE] = @COMMENT_DATE WHERE (([COMMENT_ID] = @Original_COMMENT_ID) AND ([COMMENT_DOC_ID] = @Original_COMMENT_DOC_ID) AND ([COMMENT_TITLE] = @Original_COMMENT_TITLE) AND ([COMMENT_DATE] = @Original_COMMENT_DATE));
SELECT COMMENT_ID, COMMENT_DOC_ID, COMMENT_TITLE, COMMENT_DESC, COMMENT_DATE FROM TBL_DOC_COMMENT WHERE (COMMENT_ID = @COMMENT_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@COMMENT_DOC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COMMENT_DOC_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COMMENT_TITLE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COMMENT_TITLE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COMMENT_DESC" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="COMMENT_DESC" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@COMMENT_DATE" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="COMMENT_DATE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_COMMENT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COMMENT_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_COMMENT_DOC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COMMENT_DOC_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COMMENT_TITLE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COMMENT_TITLE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_COMMENT_DATE" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="COMMENT_DATE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="COMMENT_ID" ColumnName="COMMENT_ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@COMMENT_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="COMMENT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="COMMENT_ID" DataSetColumn="COMMENT_ID" />
              <Mapping SourceColumn="COMMENT_DOC_ID" DataSetColumn="COMMENT_DOC_ID" />
              <Mapping SourceColumn="COMMENT_TITLE" DataSetColumn="COMMENT_TITLE" />
              <Mapping SourceColumn="COMMENT_DESC" DataSetColumn="COMMENT_DESC" />
              <Mapping SourceColumn="COMMENT_DATE" DataSetColumn="COMMENT_DATE" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_DOC_COMMENT" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCOMMENT_DOC_ID" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByCOMMENT_DOC_ID" GeneratorSourceName="FillByCOMMENT_DOC_ID" GetMethodModifier="Public" GetMethodName="GetDataByCOMMENT_DOC_ID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByCOMMENT_DOC_ID" UserSourceName="FillByCOMMENT_DOC_ID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     COMMENT_ID, COMMENT_DOC_ID, COMMENT_TITLE, COMMENT_DESC, COMMENT_DATE
FROM         TBL_DOC_COMMENT
WHERE     (COMMENT_DOC_ID = @COMMENT_DOC_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="COMMENT_DOC_ID" ColumnName="COMMENT_DOC_ID" DataSourceName="DIGI_DOC.dbo.TBL_DOC_COMMENT" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@COMMENT_DOC_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="COMMENT_DOC_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_DOC_COMMENT" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCOMMENT_ID" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByCOMMENT_ID" GeneratorSourceName="FillByCOMMENT_ID" GetMethodModifier="Public" GetMethodName="GetDataByCOMMENT_ID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByCOMMENT_ID" UserSourceName="FillByCOMMENT_ID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT COMMENT_ID, COMMENT_DOC_ID, COMMENT_TITLE, COMMENT_DESC, COMMENT_DATE FROM dbo.TBL_DOC_COMMENT WHERE COMMENT_ID = @COMMENT_ID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="COMMENT_ID" ColumnName="COMMENT_ID" DataSourceName="DIGI_DOC.dbo.TBL_DOC_COMMENT" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@COMMENT_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="COMMENT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_DOC_COMMENT" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCOMMENTDOC_ID" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByCOMMENTDOC_ID" GeneratorSourceName="FillByCOMMENTDOC_ID" GetMethodModifier="Public" GetMethodName="GetDataByCOMMENTDOC_ID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByCOMMENTDOC_ID" UserSourceName="FillByCOMMENTDOC_ID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT COMMENT_ID, COMMENT_DOC_ID, COMMENT_TITLE, COMMENT_DESC, COMMENT_DATE FROM dbo.TBL_DOC_COMMENT WHERE  COMMENT_DOC_ID=  @COMMENT_DOC_ID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="COMMENT_DOC_ID" ColumnName="COMMENT_DOC_ID" DataSourceName="DIGI_DOC.dbo.TBL_DOC_COMMENT" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@COMMENT_DOC_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="COMMENT_DOC_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TBL_DOC_CATTableAdapter" GeneratorDataComponentClassName="TBL_DOC_CATTableAdapter" Name="TBL_DOC_CAT" UserDataComponentName="TBL_DOC_CATTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_DOC_CAT" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[TBL_DOC_CAT] WHERE (([DOC_CAT_ID] = @Original_DOC_CAT_ID) AND ([DOC_CAT_TYPE] = @Original_DOC_CAT_TYPE) AND ([DOC_CAT_ACTIVE] = @Original_DOC_CAT_ACTIVE))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DOC_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DOC_CAT_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_CAT_TYPE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_DOC_CAT_ACTIVE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DOC_CAT_ACTIVE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[TBL_DOC_CAT] ([DOC_CAT_TYPE], [DOC_CAT_DESC], [DOC_CAT_ACTIVE]) VALUES (@DOC_CAT_TYPE, @DOC_CAT_DESC, @DOC_CAT_ACTIVE);
SELECT DOC_CAT_ID, DOC_CAT_TYPE, DOC_CAT_DESC, DOC_CAT_ACTIVE FROM TBL_DOC_CAT WHERE (DOC_CAT_ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOC_CAT_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_CAT_TYPE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOC_CAT_DESC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_CAT_DESC" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@DOC_CAT_ACTIVE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DOC_CAT_ACTIVE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT DOC_CAT_ID, DOC_CAT_TYPE, DOC_CAT_DESC, DOC_CAT_ACTIVE FROM dbo.TBL_DOC_CAT</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[TBL_DOC_CAT] SET [DOC_CAT_TYPE] = @DOC_CAT_TYPE, [DOC_CAT_DESC] = @DOC_CAT_DESC, [DOC_CAT_ACTIVE] = @DOC_CAT_ACTIVE WHERE (([DOC_CAT_ID] = @Original_DOC_CAT_ID) AND ([DOC_CAT_TYPE] = @Original_DOC_CAT_TYPE) AND ([DOC_CAT_ACTIVE] = @Original_DOC_CAT_ACTIVE));
SELECT DOC_CAT_ID, DOC_CAT_TYPE, DOC_CAT_DESC, DOC_CAT_ACTIVE FROM TBL_DOC_CAT WHERE (DOC_CAT_ID = @DOC_CAT_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOC_CAT_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_CAT_TYPE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOC_CAT_DESC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_CAT_DESC" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@DOC_CAT_ACTIVE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DOC_CAT_ACTIVE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DOC_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DOC_CAT_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_CAT_TYPE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_DOC_CAT_ACTIVE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DOC_CAT_ACTIVE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="DOC_CAT_ID" ColumnName="DOC_CAT_ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DOC_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DOC_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DOC_CAT_ID" DataSetColumn="DOC_CAT_ID" />
              <Mapping SourceColumn="DOC_CAT_TYPE" DataSetColumn="DOC_CAT_TYPE" />
              <Mapping SourceColumn="DOC_CAT_DESC" DataSetColumn="DOC_CAT_DESC" />
              <Mapping SourceColumn="DOC_CAT_ACTIVE" DataSetColumn="DOC_CAT_ACTIVE" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_DOC_CAT" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByDOC_CAT_ACTIVE" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByDOC_CAT_ACTIVE" GeneratorSourceName="FillByDOC_CAT_ACTIVE" GetMethodModifier="Public" GetMethodName="GetDataByDOC_CAT_ACTIVE" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByDOC_CAT_ACTIVE" UserSourceName="FillByDOC_CAT_ACTIVE">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     DOC_CAT_ID, DOC_CAT_TYPE, DOC_CAT_DESC, DOC_CAT_ACTIVE
FROM         TBL_DOC_CAT
WHERE     (DOC_CAT_ACTIVE = @DOC_CAT_ACTIVE)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="DOC_CAT_ACTIVE" ColumnName="DOC_CAT_ACTIVE" DataSourceName="DIGI_DOC.dbo.TBL_DOC_CAT" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@DOC_CAT_ACTIVE" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="DOC_CAT_ACTIVE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_DOC_CAT" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByDOC_CAT_ID" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByDOC_CAT_ID" GeneratorSourceName="FillByDOC_CAT_ID" GetMethodModifier="Public" GetMethodName="GetDataByDOC_CAT_ID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByDOC_CAT_ID" UserSourceName="FillByDOC_CAT_ID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     DOC_CAT_ID, DOC_CAT_TYPE, DOC_CAT_DESC, DOC_CAT_ACTIVE
FROM         TBL_DOC_CAT
WHERE     (DOC_CAT_ID = @DOC_CAT_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="DOC_CAT_ID" ColumnName="DOC_CAT_ID" DataSourceName="DIGI_DOC.dbo.TBL_DOC_CAT" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DOC_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DOC_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TBL_ATTCH_DOCTableAdapter" GeneratorDataComponentClassName="TBL_ATTCH_DOCTableAdapter" Name="TBL_ATTCH_DOC" UserDataComponentName="TBL_ATTCH_DOCTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_ATTCH_DOC" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[TBL_ATTCH_DOC] WHERE (([ATTCH_ID] = @Original_ATTCH_ID) AND ([ATTCH_DOC_ID] = @Original_ATTCH_DOC_ID) AND ([ATTCH_REF_DOC_ID] = @Original_ATTCH_REF_DOC_ID) AND ([ATTCH_DATE] = @Original_ATTCH_DATE))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ATTCH_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ATTCH_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ATTCH_DOC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ATTCH_DOC_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ATTCH_REF_DOC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ATTCH_REF_DOC_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ATTCH_DATE" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ATTCH_DATE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[TBL_ATTCH_DOC] ([ATTCH_DOC_ID], [ATTCH_REF_DOC_ID], [ATTCH_NOTE], [ATTCH_DATE]) VALUES (@ATTCH_DOC_ID, @ATTCH_REF_DOC_ID, @ATTCH_NOTE, @ATTCH_DATE);
SELECT ATTCH_ID, ATTCH_DOC_ID, ATTCH_REF_DOC_ID, ATTCH_NOTE, ATTCH_DATE FROM TBL_ATTCH_DOC WHERE (ATTCH_ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ATTCH_DOC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ATTCH_DOC_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ATTCH_REF_DOC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ATTCH_REF_DOC_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ATTCH_NOTE" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="ATTCH_NOTE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ATTCH_DATE" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ATTCH_DATE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT ATTCH_ID, ATTCH_DOC_ID, ATTCH_REF_DOC_ID, ATTCH_NOTE, ATTCH_DATE FROM dbo.TBL_ATTCH_DOC</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[TBL_ATTCH_DOC] SET [ATTCH_DOC_ID] = @ATTCH_DOC_ID, [ATTCH_REF_DOC_ID] = @ATTCH_REF_DOC_ID, [ATTCH_NOTE] = @ATTCH_NOTE, [ATTCH_DATE] = @ATTCH_DATE WHERE (([ATTCH_ID] = @Original_ATTCH_ID) AND ([ATTCH_DOC_ID] = @Original_ATTCH_DOC_ID) AND ([ATTCH_REF_DOC_ID] = @Original_ATTCH_REF_DOC_ID) AND ([ATTCH_DATE] = @Original_ATTCH_DATE));
SELECT ATTCH_ID, ATTCH_DOC_ID, ATTCH_REF_DOC_ID, ATTCH_NOTE, ATTCH_DATE FROM TBL_ATTCH_DOC WHERE (ATTCH_ID = @ATTCH_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ATTCH_DOC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ATTCH_DOC_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ATTCH_REF_DOC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ATTCH_REF_DOC_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ATTCH_NOTE" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="ATTCH_NOTE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ATTCH_DATE" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ATTCH_DATE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ATTCH_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ATTCH_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ATTCH_DOC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ATTCH_DOC_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ATTCH_REF_DOC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ATTCH_REF_DOC_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ATTCH_DATE" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ATTCH_DATE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="ATTCH_ID" ColumnName="ATTCH_ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ATTCH_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ATTCH_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ATTCH_ID" DataSetColumn="ATTCH_ID" />
              <Mapping SourceColumn="ATTCH_DOC_ID" DataSetColumn="ATTCH_DOC_ID" />
              <Mapping SourceColumn="ATTCH_REF_DOC_ID" DataSetColumn="ATTCH_REF_DOC_ID" />
              <Mapping SourceColumn="ATTCH_NOTE" DataSetColumn="ATTCH_NOTE" />
              <Mapping SourceColumn="ATTCH_DATE" DataSetColumn="ATTCH_DATE" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TBL_DOC_SUB_CATTableAdapter" GeneratorDataComponentClassName="TBL_DOC_SUB_CATTableAdapter" Name="TBL_DOC_SUB_CAT" UserDataComponentName="TBL_DOC_SUB_CATTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_DOC_SUB_CAT" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[TBL_DOC_SUB_CAT] WHERE (([DOC_SUB_CAT_ID] = @Original_DOC_SUB_CAT_ID) AND ([DOC_CAT_ID] = @Original_DOC_CAT_ID) AND ([DOC_SUB_CAT_TYPE] = @Original_DOC_SUB_CAT_TYPE) AND ([DOC_SUB_CAT_ACTIVE] = @Original_DOC_SUB_CAT_ACTIVE))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DOC_SUB_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_SUB_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DOC_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DOC_SUB_CAT_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_SUB_CAT_TYPE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_DOC_SUB_CAT_ACTIVE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DOC_SUB_CAT_ACTIVE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[TBL_DOC_SUB_CAT] ([DOC_CAT_ID], [DOC_SUB_CAT_TYPE], [DOC_SUB_CAT_DESC], [DOC_SUB_CAT_ACTIVE]) VALUES (@DOC_CAT_ID, @DOC_SUB_CAT_TYPE, @DOC_SUB_CAT_DESC, @DOC_SUB_CAT_ACTIVE);
SELECT DOC_SUB_CAT_ID, DOC_CAT_ID, DOC_SUB_CAT_TYPE, DOC_SUB_CAT_DESC, DOC_SUB_CAT_ACTIVE FROM TBL_DOC_SUB_CAT WHERE (DOC_SUB_CAT_ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DOC_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOC_SUB_CAT_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_SUB_CAT_TYPE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOC_SUB_CAT_DESC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_SUB_CAT_DESC" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@DOC_SUB_CAT_ACTIVE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DOC_SUB_CAT_ACTIVE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT DOC_SUB_CAT_ID, DOC_CAT_ID, DOC_SUB_CAT_TYPE, DOC_SUB_CAT_DESC, DOC_SUB_CAT_ACTIVE FROM dbo.TBL_DOC_SUB_CAT</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[TBL_DOC_SUB_CAT] SET [DOC_CAT_ID] = @DOC_CAT_ID, [DOC_SUB_CAT_TYPE] = @DOC_SUB_CAT_TYPE, [DOC_SUB_CAT_DESC] = @DOC_SUB_CAT_DESC, [DOC_SUB_CAT_ACTIVE] = @DOC_SUB_CAT_ACTIVE WHERE (([DOC_SUB_CAT_ID] = @Original_DOC_SUB_CAT_ID) AND ([DOC_CAT_ID] = @Original_DOC_CAT_ID) AND ([DOC_SUB_CAT_TYPE] = @Original_DOC_SUB_CAT_TYPE) AND ([DOC_SUB_CAT_ACTIVE] = @Original_DOC_SUB_CAT_ACTIVE));
SELECT DOC_SUB_CAT_ID, DOC_CAT_ID, DOC_SUB_CAT_TYPE, DOC_SUB_CAT_DESC, DOC_SUB_CAT_ACTIVE FROM TBL_DOC_SUB_CAT WHERE (DOC_SUB_CAT_ID = @DOC_SUB_CAT_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DOC_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOC_SUB_CAT_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_SUB_CAT_TYPE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOC_SUB_CAT_DESC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_SUB_CAT_DESC" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@DOC_SUB_CAT_ACTIVE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DOC_SUB_CAT_ACTIVE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DOC_SUB_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_SUB_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DOC_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOC_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DOC_SUB_CAT_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOC_SUB_CAT_TYPE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_DOC_SUB_CAT_ACTIVE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DOC_SUB_CAT_ACTIVE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="DOC_SUB_CAT_ID" ColumnName="DOC_SUB_CAT_ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DOC_SUB_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DOC_SUB_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DOC_SUB_CAT_ID" DataSetColumn="DOC_SUB_CAT_ID" />
              <Mapping SourceColumn="DOC_CAT_ID" DataSetColumn="DOC_CAT_ID" />
              <Mapping SourceColumn="DOC_SUB_CAT_TYPE" DataSetColumn="DOC_SUB_CAT_TYPE" />
              <Mapping SourceColumn="DOC_SUB_CAT_DESC" DataSetColumn="DOC_SUB_CAT_DESC" />
              <Mapping SourceColumn="DOC_SUB_CAT_ACTIVE" DataSetColumn="DOC_SUB_CAT_ACTIVE" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_DOC_SUB_CAT" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByActive" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByActive" GeneratorSourceName="FillByActive" GetMethodModifier="Public" GetMethodName="GetDataByActive" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByActive" UserSourceName="FillByActive">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     DOC_SUB_CAT_ID, DOC_CAT_ID, DOC_SUB_CAT_TYPE, DOC_SUB_CAT_DESC, DOC_SUB_CAT_ACTIVE
FROM         TBL_DOC_SUB_CAT
WHERE     (DOC_SUB_CAT_ACTIVE = @DOC_SUB_CAT_ACTIVE) AND (DOC_CAT_ID = @DOC_CAT_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="DOC_SUB_CAT_ACTIVE" ColumnName="DOC_SUB_CAT_ACTIVE" DataSourceName="DIGI_DOC.dbo.TBL_DOC_SUB_CAT" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@DOC_SUB_CAT_ACTIVE" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="DOC_SUB_CAT_ACTIVE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="DOC_CAT_ID" ColumnName="DOC_CAT_ID" DataSourceName="DIGI_DOC.dbo.TBL_DOC_SUB_CAT" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DOC_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DOC_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_DOC_SUB_CAT" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCATEGOTY_ID" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByCATEGOTY_ID" GeneratorSourceName="FillByCATEGOTY_ID" GetMethodModifier="Public" GetMethodName="GetDataByCATEGOTY_ID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByCATEGOTY_ID" UserSourceName="FillByCATEGOTY_ID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     DOC_SUB_CAT_ID, DOC_CAT_ID, DOC_SUB_CAT_TYPE, DOC_SUB_CAT_DESC, DOC_SUB_CAT_ACTIVE
FROM         TBL_DOC_SUB_CAT
WHERE     (DOC_CAT_ID = @DOC_CAT_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="DOC_CAT_ID" ColumnName="DOC_CAT_ID" DataSourceName="DIGI_DOC.dbo.TBL_DOC_SUB_CAT" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DOC_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DOC_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="V_DOCUMENTSTableAdapter" GeneratorDataComponentClassName="V_DOCUMENTSTableAdapter" Name="V_DOCUMENTS" UserDataComponentName="V_DOCUMENTSTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.V_DOCUMENTS" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     DOC_ID, DOC, DOC_TYPE, DOC_DATE, DOC_VERSION, DOC_NAME, DOC_EXT, DOC_AUTHOR, DOC_SUBJECT, DOC_KEYWORDS, DOC_TEXT, 
                      DOC_CAT_TYPE, DOC_CAT_DESC, DOC_SUB_CAT_TYPE, DOC_CAT_ID, DOC_SUB_CAT_ID, DOC_INUSE
FROM         V_DOCUMENTS</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DOC_ID" DataSetColumn="DOC_ID" />
              <Mapping SourceColumn="DOC" DataSetColumn="DOC" />
              <Mapping SourceColumn="DOC_TYPE" DataSetColumn="DOC_TYPE" />
              <Mapping SourceColumn="DOC_DATE" DataSetColumn="DOC_DATE" />
              <Mapping SourceColumn="DOC_VERSION" DataSetColumn="DOC_VERSION" />
              <Mapping SourceColumn="DOC_NAME" DataSetColumn="DOC_NAME" />
              <Mapping SourceColumn="DOC_EXT" DataSetColumn="DOC_EXT" />
              <Mapping SourceColumn="DOC_AUTHOR" DataSetColumn="DOC_AUTHOR" />
              <Mapping SourceColumn="DOC_SUBJECT" DataSetColumn="DOC_SUBJECT" />
              <Mapping SourceColumn="DOC_KEYWORDS" DataSetColumn="DOC_KEYWORDS" />
              <Mapping SourceColumn="DOC_TEXT" DataSetColumn="DOC_TEXT" />
              <Mapping SourceColumn="DOC_CAT_TYPE" DataSetColumn="DOC_CAT_TYPE" />
              <Mapping SourceColumn="DOC_CAT_DESC" DataSetColumn="DOC_CAT_DESC" />
              <Mapping SourceColumn="DOC_SUB_CAT_TYPE" DataSetColumn="DOC_SUB_CAT_TYPE" />
              <Mapping SourceColumn="DOC_CAT_ID" DataSetColumn="DOC_CAT_ID" />
              <Mapping SourceColumn="DOC_SUB_CAT_ID" DataSetColumn="DOC_SUB_CAT_ID" />
              <Mapping SourceColumn="DOC_INUSE" DataSetColumn="DOC_INUSE" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.V_DOCUMENTS" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByDOC_CAT_ID" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByDOC_CAT_ID" GeneratorSourceName="FillByDOC_CAT_ID" GetMethodModifier="Public" GetMethodName="GetDataByDOC_CAT_ID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByDOC_CAT_ID" UserSourceName="FillByDOC_CAT_ID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     DOC, DOC_AUTHOR, DOC_CAT_DESC, DOC_CAT_ID, DOC_CAT_TYPE, DOC_DATE, DOC_EXT, DOC_ID, DOC_INUSE, DOC_KEYWORDS, DOC_NAME, 
                      DOC_SUBJECT, DOC_SUB_CAT_ID, DOC_SUB_CAT_TYPE, DOC_TEXT, DOC_TYPE, DOC_VERSION
FROM         V_DOCUMENTS
WHERE     (DOC_CAT_ID = @DOC_CAT_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="DOC_CAT_ID" ColumnName="DOC_CAT_ID" DataSourceName="DIGI_DOC.dbo.V_DOCUMENTS" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DOC_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DOC_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.V_DOCUMENTS" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByDOC_ID" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByDOC_ID" GeneratorSourceName="FillByDOC_ID" GetMethodModifier="Public" GetMethodName="GetDataByDOC_ID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByDOC_ID" UserSourceName="FillByDOC_ID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT DOC, DOC_AUTHOR, DOC_CAT_DESC, DOC_CAT_ID, DOC_CAT_TYPE, DOC_DATE, DOC_EXT, DOC_ID, DOC_INUSE, DOC_KEYWORDS, DOC_NAME, DOC_SUBJECT, DOC_SUB_CAT_ID, DOC_SUB_CAT_TYPE, DOC_TEXT, DOC_TYPE, DOC_VERSION FROM V_DOCUMENTS WHERE (DOC_ID = @DOC_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="DOC_ID" ColumnName="DOC_ID" DataSourceName="DIGI_DOC.dbo.V_DOCUMENTS" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DOC_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DOC_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.V_DOCUMENTS" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByDOC_SUB_CAT_ID" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByDOC_SUB_CAT_ID" GeneratorSourceName="FillByDOC_SUB_CAT_ID" GetMethodModifier="Public" GetMethodName="GetDataByDOC_SUB_CAT_ID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByDOC_SUB_CAT_ID" UserSourceName="FillByDOC_SUB_CAT_ID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT DOC, DOC_AUTHOR, DOC_CAT_DESC, DOC_CAT_ID, DOC_CAT_TYPE, DOC_DATE, DOC_EXT, DOC_ID, DOC_INUSE, DOC_KEYWORDS, DOC_NAME, DOC_SUBJECT, DOC_SUB_CAT_ID, DOC_SUB_CAT_TYPE, DOC_TEXT, DOC_TYPE, DOC_VERSION FROM V_DOCUMENTS WHERE (DOC_SUB_CAT_ID = @DOC_SUB_CAT_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="DOC_SUB_CAT_ID" ColumnName="DOC_SUB_CAT_ID" DataSourceName="DIGI_DOC.dbo.V_DOCUMENTS" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DOC_SUB_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DOC_SUB_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TBL_ACCOUNTTableAdapter" GeneratorDataComponentClassName="TBL_ACCOUNTTableAdapter" Name="TBL_ACCOUNT" UserDataComponentName="TBL_ACCOUNTTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_ACCOUNT" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[TBL_ACCOUNT] WHERE (([ACCT_ID] = @Original_ACCT_ID) AND ([ACCT_NAME] = @Original_ACCT_NAME) AND ([ACCT_LASTNAME] = @Original_ACCT_LASTNAME) AND ([ACCT_ADD1] = @Original_ACCT_ADD1) AND ((@IsNull_ACCT_ADD2 = 1 AND [ACCT_ADD2] IS NULL) OR ([ACCT_ADD2] = @Original_ACCT_ADD2)) AND ((@IsNull_ACCT_ADD3 = 1 AND [ACCT_ADD3] IS NULL) OR ([ACCT_ADD3] = @Original_ACCT_ADD3)) AND ((@IsNull_ACCT_CITY = 1 AND [ACCT_CITY] IS NULL) OR ([ACCT_CITY] = @Original_ACCT_CITY)) AND ([ACCT_STATE] = @Original_ACCT_STATE) AND ([ACCT_ZIPCODE] = @Original_ACCT_ZIPCODE) AND ((@IsNull_ACCT_ZIPCODE2 = 1 AND [ACCT_ZIPCODE2] IS NULL) OR ([ACCT_ZIPCODE2] = @Original_ACCT_ZIPCODE2)) AND ([ACCT_PHY1] = @Original_ACCT_PHY1) AND ((@IsNull_ACCT_PHY2 = 1 AND [ACCT_PHY2] IS NULL) OR ([ACCT_PHY2] = @Original_ACCT_PHY2)) AND ((@IsNull_ACCT_PHY3 = 1 AND [ACCT_PHY3] IS NULL) OR ([ACCT_PHY3] = @Original_ACCT_PHY3)) AND ((@IsNull_ACCT_PHYCITY = 1 AND [ACCT_PHYCITY] IS NULL) OR ([ACCT_PHYCITY] = @Original_ACCT_PHYCITY)) AND ([ACCT_PHYSTATE] = @Original_ACCT_PHYSTATE) AND ([ACCT_PHYZIPCODE] = @Original_ACCT_PHYZIPCODE) AND ((@IsNull_ACCT_EMAIL = 1 AND [ACCT_EMAIL] IS NULL) OR ([ACCT_EMAIL] = @Original_ACCT_EMAIL)) AND ([ACCT_USERNAME] = @Original_ACCT_USERNAME) AND ([ACCT_PASSWORD] = @Original_ACCT_PASSWORD))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ACCT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_NAME" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_LASTNAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_LASTNAME" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_ADD1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_ADD1" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCT_ADD2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_ADD2" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_ADD2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_ADD2" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCT_ADD3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_ADD3" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_ADD3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_ADD3" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCT_CITY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_CITY" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_CITY" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_CITY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_STATE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_STATE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_ZIPCODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_ZIPCODE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCT_ZIPCODE2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_ZIPCODE2" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_ZIPCODE2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_ZIPCODE2" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_PHY1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHY1" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCT_PHY2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_PHY2" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_PHY2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHY2" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCT_PHY3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_PHY3" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_PHY3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHY3" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCT_PHYCITY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_PHYCITY" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_PHYCITY" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHYCITY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_PHYSTATE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHYSTATE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_PHYZIPCODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHYZIPCODE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCT_EMAIL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_EMAIL" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_EMAIL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_EMAIL" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_USERNAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_USERNAME" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_PASSWORD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PASSWORD" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[TBL_ACCOUNT] ([ACCT_NAME], [ACCT_LASTNAME], [ACCT_ADD1], [ACCT_ADD2], [ACCT_ADD3], [ACCT_CITY], [ACCT_STATE], [ACCT_ZIPCODE], [ACCT_ZIPCODE2], [ACCT_PHY1], [ACCT_PHY2], [ACCT_PHY3], [ACCT_PHYCITY], [ACCT_PHYSTATE], [ACCT_PHYZIPCODE], [ACCT_EMAIL], [ACCT_USERNAME], [ACCT_PASSWORD]) VALUES (@ACCT_NAME, @ACCT_LASTNAME, @ACCT_ADD1, @ACCT_ADD2, @ACCT_ADD3, @ACCT_CITY, @ACCT_STATE, @ACCT_ZIPCODE, @ACCT_ZIPCODE2, @ACCT_PHY1, @ACCT_PHY2, @ACCT_PHY3, @ACCT_PHYCITY, @ACCT_PHYSTATE, @ACCT_PHYZIPCODE, @ACCT_EMAIL, @ACCT_USERNAME, @ACCT_PASSWORD);
SELECT ACCT_ID, ACCT_NAME, ACCT_LASTNAME, ACCT_ADD1, ACCT_ADD2, ACCT_ADD3, ACCT_CITY, ACCT_STATE, ACCT_ZIPCODE, ACCT_ZIPCODE2, ACCT_PHY1, ACCT_PHY2, ACCT_PHY3, ACCT_PHYCITY, ACCT_PHYSTATE, ACCT_PHYZIPCODE, ACCT_EMAIL, ACCT_USERNAME, ACCT_PASSWORD FROM TBL_ACCOUNT WHERE (ACCT_PASSWORD = @ACCT_PASSWORD) AND (ACCT_USERNAME = @ACCT_USERNAME)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_NAME" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_LASTNAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_LASTNAME" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_ADD1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_ADD1" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_ADD2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_ADD2" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_ADD3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_ADD3" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_CITY" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_CITY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_STATE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_STATE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_ZIPCODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_ZIPCODE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_ZIPCODE2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_ZIPCODE2" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_PHY1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHY1" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_PHY2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHY2" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_PHY3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHY3" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_PHYCITY" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHYCITY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_PHYSTATE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHYSTATE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_PHYZIPCODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHYZIPCODE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_EMAIL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_EMAIL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_USERNAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_USERNAME" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_PASSWORD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PASSWORD" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT ACCT_ID, ACCT_NAME, ACCT_LASTNAME, ACCT_ADD1, ACCT_ADD2, ACCT_ADD3, ACCT_CITY, ACCT_STATE, ACCT_ZIPCODE, ACCT_ZIPCODE2, ACCT_PHY1, ACCT_PHY2, ACCT_PHY3, ACCT_PHYCITY, ACCT_PHYSTATE, ACCT_PHYZIPCODE, ACCT_EMAIL, ACCT_USERNAME, ACCT_PASSWORD FROM dbo.TBL_ACCOUNT</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[TBL_ACCOUNT] SET [ACCT_NAME] = @ACCT_NAME, [ACCT_LASTNAME] = @ACCT_LASTNAME, [ACCT_ADD1] = @ACCT_ADD1, [ACCT_ADD2] = @ACCT_ADD2, [ACCT_ADD3] = @ACCT_ADD3, [ACCT_CITY] = @ACCT_CITY, [ACCT_STATE] = @ACCT_STATE, [ACCT_ZIPCODE] = @ACCT_ZIPCODE, [ACCT_ZIPCODE2] = @ACCT_ZIPCODE2, [ACCT_PHY1] = @ACCT_PHY1, [ACCT_PHY2] = @ACCT_PHY2, [ACCT_PHY3] = @ACCT_PHY3, [ACCT_PHYCITY] = @ACCT_PHYCITY, [ACCT_PHYSTATE] = @ACCT_PHYSTATE, [ACCT_PHYZIPCODE] = @ACCT_PHYZIPCODE, [ACCT_EMAIL] = @ACCT_EMAIL, [ACCT_USERNAME] = @ACCT_USERNAME, [ACCT_PASSWORD] = @ACCT_PASSWORD WHERE (([ACCT_ID] = @Original_ACCT_ID) AND ([ACCT_NAME] = @Original_ACCT_NAME) AND ([ACCT_LASTNAME] = @Original_ACCT_LASTNAME) AND ([ACCT_ADD1] = @Original_ACCT_ADD1) AND ((@IsNull_ACCT_ADD2 = 1 AND [ACCT_ADD2] IS NULL) OR ([ACCT_ADD2] = @Original_ACCT_ADD2)) AND ((@IsNull_ACCT_ADD3 = 1 AND [ACCT_ADD3] IS NULL) OR ([ACCT_ADD3] = @Original_ACCT_ADD3)) AND ((@IsNull_ACCT_CITY = 1 AND [ACCT_CITY] IS NULL) OR ([ACCT_CITY] = @Original_ACCT_CITY)) AND ([ACCT_STATE] = @Original_ACCT_STATE) AND ([ACCT_ZIPCODE] = @Original_ACCT_ZIPCODE) AND ((@IsNull_ACCT_ZIPCODE2 = 1 AND [ACCT_ZIPCODE2] IS NULL) OR ([ACCT_ZIPCODE2] = @Original_ACCT_ZIPCODE2)) AND ([ACCT_PHY1] = @Original_ACCT_PHY1) AND ((@IsNull_ACCT_PHY2 = 1 AND [ACCT_PHY2] IS NULL) OR ([ACCT_PHY2] = @Original_ACCT_PHY2)) AND ((@IsNull_ACCT_PHY3 = 1 AND [ACCT_PHY3] IS NULL) OR ([ACCT_PHY3] = @Original_ACCT_PHY3)) AND ((@IsNull_ACCT_PHYCITY = 1 AND [ACCT_PHYCITY] IS NULL) OR ([ACCT_PHYCITY] = @Original_ACCT_PHYCITY)) AND ([ACCT_PHYSTATE] = @Original_ACCT_PHYSTATE) AND ([ACCT_PHYZIPCODE] = @Original_ACCT_PHYZIPCODE) AND ((@IsNull_ACCT_EMAIL = 1 AND [ACCT_EMAIL] IS NULL) OR ([ACCT_EMAIL] = @Original_ACCT_EMAIL)) AND ([ACCT_USERNAME] = @Original_ACCT_USERNAME) AND ([ACCT_PASSWORD] = @Original_ACCT_PASSWORD));
SELECT ACCT_ID, ACCT_NAME, ACCT_LASTNAME, ACCT_ADD1, ACCT_ADD2, ACCT_ADD3, ACCT_CITY, ACCT_STATE, ACCT_ZIPCODE, ACCT_ZIPCODE2, ACCT_PHY1, ACCT_PHY2, ACCT_PHY3, ACCT_PHYCITY, ACCT_PHYSTATE, ACCT_PHYZIPCODE, ACCT_EMAIL, ACCT_USERNAME, ACCT_PASSWORD FROM TBL_ACCOUNT WHERE (ACCT_PASSWORD = @ACCT_PASSWORD) AND (ACCT_USERNAME = @ACCT_USERNAME)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_NAME" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_LASTNAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_LASTNAME" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_ADD1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_ADD1" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_ADD2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_ADD2" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_ADD3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_ADD3" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_CITY" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_CITY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_STATE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_STATE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_ZIPCODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_ZIPCODE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_ZIPCODE2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_ZIPCODE2" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_PHY1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHY1" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_PHY2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHY2" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_PHY3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHY3" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_PHYCITY" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHYCITY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_PHYSTATE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHYSTATE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_PHYZIPCODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHYZIPCODE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_EMAIL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_EMAIL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_USERNAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_USERNAME" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCT_PASSWORD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PASSWORD" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ACCT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_NAME" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_LASTNAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_LASTNAME" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_ADD1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_ADD1" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCT_ADD2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_ADD2" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_ADD2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_ADD2" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCT_ADD3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_ADD3" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_ADD3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_ADD3" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCT_CITY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_CITY" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_CITY" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_CITY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_STATE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_STATE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_ZIPCODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_ZIPCODE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCT_ZIPCODE2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_ZIPCODE2" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_ZIPCODE2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_ZIPCODE2" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_PHY1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHY1" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCT_PHY2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_PHY2" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_PHY2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHY2" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCT_PHY3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_PHY3" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_PHY3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHY3" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCT_PHYCITY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_PHYCITY" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_PHYCITY" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHYCITY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_PHYSTATE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHYSTATE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_PHYZIPCODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PHYZIPCODE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCT_EMAIL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_EMAIL" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_EMAIL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_EMAIL" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_USERNAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_USERNAME" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCT_PASSWORD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCT_PASSWORD" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ACCT_ID" DataSetColumn="ACCT_ID" />
              <Mapping SourceColumn="ACCT_NAME" DataSetColumn="ACCT_NAME" />
              <Mapping SourceColumn="ACCT_LASTNAME" DataSetColumn="ACCT_LASTNAME" />
              <Mapping SourceColumn="ACCT_ADD1" DataSetColumn="ACCT_ADD1" />
              <Mapping SourceColumn="ACCT_ADD2" DataSetColumn="ACCT_ADD2" />
              <Mapping SourceColumn="ACCT_ADD3" DataSetColumn="ACCT_ADD3" />
              <Mapping SourceColumn="ACCT_CITY" DataSetColumn="ACCT_CITY" />
              <Mapping SourceColumn="ACCT_STATE" DataSetColumn="ACCT_STATE" />
              <Mapping SourceColumn="ACCT_ZIPCODE" DataSetColumn="ACCT_ZIPCODE" />
              <Mapping SourceColumn="ACCT_ZIPCODE2" DataSetColumn="ACCT_ZIPCODE2" />
              <Mapping SourceColumn="ACCT_PHY1" DataSetColumn="ACCT_PHY1" />
              <Mapping SourceColumn="ACCT_PHY2" DataSetColumn="ACCT_PHY2" />
              <Mapping SourceColumn="ACCT_PHY3" DataSetColumn="ACCT_PHY3" />
              <Mapping SourceColumn="ACCT_PHYCITY" DataSetColumn="ACCT_PHYCITY" />
              <Mapping SourceColumn="ACCT_PHYSTATE" DataSetColumn="ACCT_PHYSTATE" />
              <Mapping SourceColumn="ACCT_PHYZIPCODE" DataSetColumn="ACCT_PHYZIPCODE" />
              <Mapping SourceColumn="ACCT_EMAIL" DataSetColumn="ACCT_EMAIL" />
              <Mapping SourceColumn="ACCT_USERNAME" DataSetColumn="ACCT_USERNAME" />
              <Mapping SourceColumn="ACCT_PASSWORD" DataSetColumn="ACCT_PASSWORD" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="DeleteQueryByACCT_ID" Modifier="Public" Name="DeleteQueryByACCT_ID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="DeleteQueryByACCT_ID">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>DELETE FROM TBL_ACCOUNT
WHERE     (ACCT_ID = @ACCT_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="ACCT_ID" ColumnName="ACCT_ID" DataSourceName="db_VirtualDesk.dbo.TBL_ACCOUNT" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ACCT_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ACCT_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_ACCOUNT" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByACCT_ID" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByACCT_ID" GeneratorSourceName="FillByACCT_ID" GetMethodModifier="Public" GetMethodName="GetDataByACCT_ID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByACCT_ID" UserSourceName="FillByACCT_ID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT ACCT_ADD1, ACCT_ADD2, ACCT_ADD3, ACCT_CITY, ACCT_EMAIL, ACCT_ID, ACCT_LASTNAME, ACCT_NAME, ACCT_PASSWORD, ACCT_PHY1, ACCT_PHY2, ACCT_PHY3, ACCT_PHYCITY, ACCT_PHYSTATE, ACCT_PHYZIPCODE, ACCT_STATE, ACCT_USERNAME, ACCT_ZIPCODE, ACCT_ZIPCODE2 FROM TBL_ACCOUNT WHERE (ACCT_ID = @ACCT_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="ACCT_ID" ColumnName="ACCT_ID" DataSourceName="DIGI_DOC.dbo.TBL_ACCOUNT" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ACCT_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ACCT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TBL_ZIPCODESTableAdapter" GeneratorDataComponentClassName="TBL_ZIPCODESTableAdapter" Name="TBL_ZIPCODES" UserDataComponentName="TBL_ZIPCODESTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_ZIPCODES" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[TBL_ZIPCODES] WHERE (([ZIPCODEID] = @Original_ZIPCODEID) AND ([ZIPCODE] = @Original_ZIPCODE) AND ([CITY] = @Original_CITY) AND ((@IsNull_STATE = 1 AND [STATE] IS NULL) OR ([STATE] = @Original_STATE)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ZIPCODEID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZIPCODEID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ZIPCODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ZIPCODE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CITY" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CITY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_STATE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="STATE" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_STATE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STATE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[TBL_ZIPCODES] ([ZIPCODEID], [ZIPCODE], [CITY], [STATE]) VALUES (@ZIPCODEID, @ZIPCODE, @CITY, @STATE);
SELECT ZIPCODEID, ZIPCODE, CITY, STATE FROM TBL_ZIPCODES WHERE (ZIPCODEID = @ZIPCODEID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ZIPCODEID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZIPCODEID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ZIPCODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ZIPCODE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CITY" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CITY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@STATE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STATE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT ZIPCODEID, ZIPCODE, CITY, STATE FROM dbo.TBL_ZIPCODES</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[TBL_ZIPCODES] SET [ZIPCODEID] = @ZIPCODEID, [ZIPCODE] = @ZIPCODE, [CITY] = @CITY, [STATE] = @STATE WHERE (([ZIPCODEID] = @Original_ZIPCODEID) AND ([ZIPCODE] = @Original_ZIPCODE) AND ([CITY] = @Original_CITY) AND ((@IsNull_STATE = 1 AND [STATE] IS NULL) OR ([STATE] = @Original_STATE)));
SELECT ZIPCODEID, ZIPCODE, CITY, STATE FROM TBL_ZIPCODES WHERE (ZIPCODEID = @ZIPCODEID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ZIPCODEID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZIPCODEID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ZIPCODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ZIPCODE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CITY" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CITY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@STATE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STATE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ZIPCODEID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZIPCODEID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ZIPCODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ZIPCODE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CITY" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CITY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_STATE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="STATE" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_STATE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STATE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ZIPCODEID" DataSetColumn="ZIPCODEID" />
              <Mapping SourceColumn="ZIPCODE" DataSetColumn="ZIPCODE" />
              <Mapping SourceColumn="CITY" DataSetColumn="CITY" />
              <Mapping SourceColumn="STATE" DataSetColumn="STATE" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_ZIPCODES" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCITY" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByCITY" GeneratorSourceName="FillByCITY" GetMethodModifier="Public" GetMethodName="GetDataByCITY" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByCITY" UserSourceName="FillByCITY">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT ZIPCODEID, ZIPCODE, CITY, STATE FROM dbo.TBL_ZIPCODES WHERE CITY = @CITY</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="CITY" ColumnName="CITY" DataSourceName="DIGI_DOC.dbo.TBL_ZIPCODES" DataTypeServer="varchar(15)" DbType="AnsiString" Direction="Input" ParameterName="@CITY" Precision="0" ProviderType="VarChar" Scale="0" Size="15" SourceColumn="CITY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_ZIPCODES" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCITYDistinct" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByCITYDistinct" GeneratorSourceName="FillByCITYDistinct" GetMethodModifier="Public" GetMethodName="GetDataByCITYDistinct" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByCITYDistinct" UserSourceName="FillByCITYDistinct">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT DISTINCT CITY FROM dbo.TBL_ZIPCODES</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TBL_ACCTOUNT_SECURITYTableAdapter" GeneratorDataComponentClassName="TBL_ACCTOUNT_SECURITYTableAdapter" Name="TBL_ACCTOUNT_SECURITY" UserDataComponentName="TBL_ACCTOUNT_SECURITYTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_ACCTOUNT_SECURITY" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[TBL_ACCTOUNT_SECURITY] WHERE (([ACC_PER_ID] = @Original_ACC_PER_ID) AND ([ACCT_ID] = @Original_ACCT_ID) AND ([ACCT_LOAD] = @Original_ACCT_LOAD) AND ([ACCT_REANONLY] = @Original_ACCT_REANONLY) AND ([ACCT_DELETE] = @Original_ACCT_DELETE) AND ([ACCT_COMMENT] = @Original_ACCT_COMMENT) AND ([ACCT_VERSION] = @Original_ACCT_VERSION) AND ([ACCT_CREATECOPY] = @Original_ACCT_CREATECOPY) AND ([ACCT_DUPLICATE] = @Original_ACCT_DUPLICATE) AND ([ACCT_DOC_SUB_CAT_ID] = @Original_ACCT_DOC_SUB_CAT_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ACC_PER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACC_PER_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ACCT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ACCT_LOAD" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_LOAD" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ACCT_REANONLY" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_REANONLY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ACCT_DELETE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_DELETE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ACCT_COMMENT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_COMMENT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ACCT_VERSION" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_VERSION" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ACCT_CREATECOPY" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_CREATECOPY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ACCT_DUPLICATE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_DUPLICATE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ACCT_DOC_SUB_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_DOC_SUB_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[TBL_ACCTOUNT_SECURITY] ([ACCT_ID], [ACCT_LOAD], [ACCT_REANONLY], [ACCT_DELETE], [ACCT_COMMENT], [ACCT_VERSION], [ACCT_CREATECOPY], [ACCT_DUPLICATE], [ACCT_DOC_SUB_CAT_ID]) VALUES (@ACCT_ID, @ACCT_LOAD, @ACCT_REANONLY, @ACCT_DELETE, @ACCT_COMMENT, @ACCT_VERSION, @ACCT_CREATECOPY, @ACCT_DUPLICATE, @ACCT_DOC_SUB_CAT_ID);
SELECT ACC_PER_ID, ACCT_ID, ACCT_LOAD, ACCT_REANONLY, ACCT_DELETE, ACCT_COMMENT, ACCT_VERSION, ACCT_CREATECOPY, ACCT_DUPLICATE, ACCT_DOC_SUB_CAT_ID FROM TBL_ACCTOUNT_SECURITY WHERE (ACC_PER_ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ACCT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ACCT_LOAD" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_LOAD" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ACCT_REANONLY" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_REANONLY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ACCT_DELETE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_DELETE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ACCT_COMMENT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_COMMENT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ACCT_VERSION" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_VERSION" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ACCT_CREATECOPY" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_CREATECOPY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ACCT_DUPLICATE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_DUPLICATE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ACCT_DOC_SUB_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_DOC_SUB_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT ACC_PER_ID, ACCT_ID, ACCT_LOAD, ACCT_REANONLY, ACCT_DELETE, ACCT_COMMENT, ACCT_VERSION, ACCT_CREATECOPY, ACCT_DUPLICATE, ACCT_DOC_SUB_CAT_ID FROM dbo.TBL_ACCTOUNT_SECURITY</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[TBL_ACCTOUNT_SECURITY] SET [ACCT_ID] = @ACCT_ID, [ACCT_LOAD] = @ACCT_LOAD, [ACCT_REANONLY] = @ACCT_REANONLY, [ACCT_DELETE] = @ACCT_DELETE, [ACCT_COMMENT] = @ACCT_COMMENT, [ACCT_VERSION] = @ACCT_VERSION, [ACCT_CREATECOPY] = @ACCT_CREATECOPY, [ACCT_DUPLICATE] = @ACCT_DUPLICATE, [ACCT_DOC_SUB_CAT_ID] = @ACCT_DOC_SUB_CAT_ID WHERE (([ACC_PER_ID] = @Original_ACC_PER_ID) AND ([ACCT_ID] = @Original_ACCT_ID) AND ([ACCT_LOAD] = @Original_ACCT_LOAD) AND ([ACCT_REANONLY] = @Original_ACCT_REANONLY) AND ([ACCT_DELETE] = @Original_ACCT_DELETE) AND ([ACCT_COMMENT] = @Original_ACCT_COMMENT) AND ([ACCT_VERSION] = @Original_ACCT_VERSION) AND ([ACCT_CREATECOPY] = @Original_ACCT_CREATECOPY) AND ([ACCT_DUPLICATE] = @Original_ACCT_DUPLICATE) AND ([ACCT_DOC_SUB_CAT_ID] = @Original_ACCT_DOC_SUB_CAT_ID));
SELECT ACC_PER_ID, ACCT_ID, ACCT_LOAD, ACCT_REANONLY, ACCT_DELETE, ACCT_COMMENT, ACCT_VERSION, ACCT_CREATECOPY, ACCT_DUPLICATE, ACCT_DOC_SUB_CAT_ID FROM TBL_ACCTOUNT_SECURITY WHERE (ACC_PER_ID = @ACC_PER_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ACCT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ACCT_LOAD" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_LOAD" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ACCT_REANONLY" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_REANONLY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ACCT_DELETE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_DELETE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ACCT_COMMENT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_COMMENT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ACCT_VERSION" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_VERSION" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ACCT_CREATECOPY" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_CREATECOPY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ACCT_DUPLICATE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_DUPLICATE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ACCT_DOC_SUB_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_DOC_SUB_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ACC_PER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACC_PER_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ACCT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ACCT_LOAD" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_LOAD" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ACCT_REANONLY" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_REANONLY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ACCT_DELETE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_DELETE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ACCT_COMMENT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_COMMENT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ACCT_VERSION" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_VERSION" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ACCT_CREATECOPY" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_CREATECOPY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ACCT_DUPLICATE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACCT_DUPLICATE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ACCT_DOC_SUB_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCT_DOC_SUB_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="ACC_PER_ID" ColumnName="ACC_PER_ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ACC_PER_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ACC_PER_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ACC_PER_ID" DataSetColumn="ACC_PER_ID" />
              <Mapping SourceColumn="ACCT_ID" DataSetColumn="ACCT_ID" />
              <Mapping SourceColumn="ACCT_LOAD" DataSetColumn="ACCT_LOAD" />
              <Mapping SourceColumn="ACCT_REANONLY" DataSetColumn="ACCT_REANONLY" />
              <Mapping SourceColumn="ACCT_DELETE" DataSetColumn="ACCT_DELETE" />
              <Mapping SourceColumn="ACCT_COMMENT" DataSetColumn="ACCT_COMMENT" />
              <Mapping SourceColumn="ACCT_VERSION" DataSetColumn="ACCT_VERSION" />
              <Mapping SourceColumn="ACCT_CREATECOPY" DataSetColumn="ACCT_CREATECOPY" />
              <Mapping SourceColumn="ACCT_DUPLICATE" DataSetColumn="ACCT_DUPLICATE" />
              <Mapping SourceColumn="ACCT_DOC_SUB_CAT_ID" DataSetColumn="ACCT_DOC_SUB_CAT_ID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_ACCTOUNT_SECURITY" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByACC_PER_ID" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByACC_PER_ID" GeneratorSourceName="FillByACC_PER_ID" GetMethodModifier="Public" GetMethodName="GetDataByACC_PER_ID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByACC_PER_ID" UserSourceName="FillByACC_PER_ID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT ACC_PER_ID, ACCT_ID, ACCT_LOAD, ACCT_REANONLY, ACCT_DELETE, ACCT_COMMENT, ACCT_VERSION, ACCT_CREATECOPY, ACCT_DUPLICATE, ACCT_DOC_SUB_CAT_ID FROM dbo.TBL_ACCTOUNT_SECURITY WHERE ACC_PER_ID=@ACC_PER_ID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="ACC_PER_ID" ColumnName="ACC_PER_ID" DataSourceName="db_VirtualDesk.dbo.TBL_ACCTOUNT_SECURITY" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ACC_PER_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ACC_PER_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_ACCTOUNT_SECURITY" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByACCT_DOC_SUB_CAT_ID" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByACCT_DOC_SUB_CAT_ID" GeneratorSourceName="FillByACCT_DOC_SUB_CAT_ID" GetMethodModifier="Public" GetMethodName="GetDataByACCT_DOC_SUB_CAT_ID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByACCT_DOC_SUB_CAT_ID" UserSourceName="FillByACCT_DOC_SUB_CAT_ID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT ACC_PER_ID, ACCT_ID, ACCT_LOAD, ACCT_REANONLY, ACCT_DELETE, ACCT_COMMENT, ACCT_VERSION, ACCT_CREATECOPY, ACCT_DUPLICATE, ACCT_DOC_SUB_CAT_ID FROM dbo.TBL_ACCTOUNT_SECURITY WHERE ACCT_ID = @ACCT_ID AND  ACCT_DOC_SUB_CAT_ID = @ACCT_DOC_SUB_CAT_ID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="ACCT_ID" ColumnName="ACCT_ID" DataSourceName="db_VirtualDesk.dbo.TBL_ACCTOUNT_SECURITY" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ACCT_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ACCT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="ACCT_DOC_SUB_CAT_ID" ColumnName="ACCT_DOC_SUB_CAT_ID" DataSourceName="db_VirtualDesk.dbo.TBL_ACCTOUNT_SECURITY" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ACCT_DOC_SUB_CAT_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ACCT_DOC_SUB_CAT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="db_VirtualDeskConnectionString (MySettings)" DbObjectName="db_VirtualDesk.dbo.TBL_ACCTOUNT_SECURITY" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByACCT_ID" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByACCT_ID" GeneratorSourceName="FillByACCT_ID" GetMethodModifier="Public" GetMethodName="GetDataByACCT_ID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByACCT_ID" UserSourceName="FillByACCT_ID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT ACC_PER_ID, ACCT_ID, ACCT_LOAD, ACCT_REANONLY, ACCT_DELETE, ACCT_COMMENT, ACCT_VERSION, ACCT_CREATECOPY, ACCT_DUPLICATE, ACCT_DOC_SUB_CAT_ID FROM dbo.TBL_ACCTOUNT_SECURITY WHERE ACCT_ID = @ACCT_ID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="ACCT_ID" ColumnName="ACCT_ID" DataSourceName="db_VirtualDesk.dbo.TBL_ACCTOUNT_SECURITY" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ACCT_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ACCT_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DsTempList" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DsTempList" msprop:Generator_DataSetName="DsTempList">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="TempList" msprop:Generator_UserTableName="TempList" msprop:Generator_RowDeletedName="TempListRowDeleted" msprop:Generator_RowChangedName="TempListRowChanged" msprop:Generator_RowClassName="TempListRow" msprop:Generator_RowChangingName="TempListRowChanging" msprop:Generator_RowEvArgName="TempListRowChangeEvent" msprop:Generator_RowEvHandlerName="TempListRowChangeEventHandler" msprop:Generator_TableClassName="TempListDataTable" msprop:Generator_TableVarName="tableTempList" msprop:Generator_RowDeletingName="TempListRowDeleting" msprop:Generator_TablePropName="TempList">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DOC_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="DOC_ID" msprop:Generator_ColumnPropNameInRow="DOC_ID" msprop:Generator_ColumnVarNameInTable="columnDOC_ID" msprop:Generator_ColumnPropNameInTable="DOC_IDColumn" type="xs:int" />
              <xs:element name="DOC_CAT_ID" msprop:Generator_UserColumnName="DOC_CAT_ID" msprop:Generator_ColumnPropNameInRow="DOC_CAT_ID" msprop:Generator_ColumnVarNameInTable="columnDOC_CAT_ID" msprop:Generator_ColumnPropNameInTable="DOC_CAT_IDColumn" type="xs:int" />
              <xs:element name="DOC_SUB_CAT_ID" msprop:Generator_UserColumnName="DOC_SUB_CAT_ID" msprop:Generator_ColumnPropNameInRow="DOC_SUB_CAT_ID" msprop:Generator_ColumnVarNameInTable="columnDOC_SUB_CAT_ID" msprop:Generator_ColumnPropNameInTable="DOC_SUB_CAT_IDColumn" type="xs:int" />
              <xs:element name="DOC" msprop:Generator_UserColumnName="DOC" msprop:Generator_ColumnPropNameInRow="DOC" msprop:Generator_ColumnVarNameInTable="columnDOC" msprop:Generator_ColumnPropNameInTable="DOCColumn" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="DOC_TYPE" msprop:Generator_UserColumnName="DOC_TYPE" msprop:Generator_ColumnPropNameInRow="DOC_TYPE" msprop:Generator_ColumnVarNameInTable="columnDOC_TYPE" msprop:Generator_ColumnPropNameInTable="DOC_TYPEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_DATE" msprop:Generator_UserColumnName="DOC_DATE" msprop:Generator_ColumnPropNameInRow="DOC_DATE" msprop:Generator_ColumnVarNameInTable="columnDOC_DATE" msprop:Generator_ColumnPropNameInTable="DOC_DATEColumn" type="xs:dateTime" />
              <xs:element name="DOC_VERSION" msprop:Generator_UserColumnName="DOC_VERSION" msprop:Generator_ColumnPropNameInRow="DOC_VERSION" msprop:Generator_ColumnVarNameInTable="columnDOC_VERSION" msprop:Generator_ColumnPropNameInTable="DOC_VERSIONColumn" type="xs:decimal" />
              <xs:element name="DOC_NAME" msprop:Generator_UserColumnName="DOC_NAME" msprop:Generator_ColumnPropNameInRow="DOC_NAME" msprop:Generator_ColumnVarNameInTable="columnDOC_NAME" msprop:Generator_ColumnPropNameInTable="DOC_NAMEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_EXT" msprop:Generator_UserColumnName="DOC_EXT" msprop:Generator_ColumnPropNameInRow="DOC_EXT" msprop:Generator_ColumnVarNameInTable="columnDOC_EXT" msprop:Generator_ColumnPropNameInTable="DOC_EXTColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_AUTHOR" msprop:Generator_UserColumnName="DOC_AUTHOR" msprop:Generator_ColumnPropNameInRow="DOC_AUTHOR" msprop:Generator_ColumnVarNameInTable="columnDOC_AUTHOR" msprop:Generator_ColumnPropNameInTable="DOC_AUTHORColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="85" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_SUBJECT" msprop:Generator_UserColumnName="DOC_SUBJECT" msprop:Generator_ColumnPropNameInRow="DOC_SUBJECT" msprop:Generator_ColumnVarNameInTable="columnDOC_SUBJECT" msprop:Generator_ColumnPropNameInTable="DOC_SUBJECTColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_KEYWORDS" msprop:Generator_UserColumnName="DOC_KEYWORDS" msprop:Generator_ColumnPropNameInRow="DOC_KEYWORDS" msprop:Generator_ColumnVarNameInTable="columnDOC_KEYWORDS" msprop:Generator_ColumnPropNameInTable="DOC_KEYWORDSColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_TEXT" msprop:Generator_UserColumnName="DOC_TEXT" msprop:Generator_ColumnPropNameInRow="DOC_TEXT" msprop:Generator_ColumnVarNameInTable="columnDOC_TEXT" msprop:Generator_ColumnPropNameInTable="DOC_TEXTColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_INUSE" msprop:Generator_UserColumnName="DOC_INUSE" msprop:Generator_ColumnVarNameInTable="columnDOC_INUSE" msprop:Generator_ColumnPropNameInRow="DOC_INUSE" msprop:Generator_ColumnPropNameInTable="DOC_INUSEColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="DOC_USERID" msprop:Generator_UserColumnName="DOC_USERID" msprop:Generator_ColumnPropNameInRow="DOC_USERID" msprop:Generator_ColumnVarNameInTable="columnDOC_USERID" msprop:Generator_ColumnPropNameInTable="DOC_USERIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="DOC_PATH" msprop:Generator_UserColumnName="DOC_PATH" msprop:Generator_ColumnPropNameInRow="DOC_PATH" msprop:Generator_ColumnVarNameInTable="columnDOC_PATH" msprop:Generator_ColumnPropNameInTable="DOC_PATHColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TBL_DOC" msprop:Generator_UserTableName="TBL_DOC" msprop:Generator_RowDeletedName="TBL_DOCRowDeleted" msprop:Generator_RowChangedName="TBL_DOCRowChanged" msprop:Generator_RowClassName="TBL_DOCRow" msprop:Generator_RowChangingName="TBL_DOCRowChanging" msprop:Generator_RowEvArgName="TBL_DOCRowChangeEvent" msprop:Generator_RowEvHandlerName="TBL_DOCRowChangeEventHandler" msprop:Generator_TableClassName="TBL_DOCDataTable" msprop:Generator_TableVarName="tableTBL_DOC" msprop:Generator_RowDeletingName="TBL_DOCRowDeleting" msprop:Generator_TablePropName="TBL_DOC">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DOC_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="DOC_ID" msprop:Generator_ColumnPropNameInRow="DOC_ID" msprop:Generator_ColumnVarNameInTable="columnDOC_ID" msprop:Generator_ColumnPropNameInTable="DOC_IDColumn" type="xs:int" />
              <xs:element name="DOC_CAT_ID" msprop:Generator_UserColumnName="DOC_CAT_ID" msprop:Generator_ColumnPropNameInRow="DOC_CAT_ID" msprop:Generator_ColumnVarNameInTable="columnDOC_CAT_ID" msprop:Generator_ColumnPropNameInTable="DOC_CAT_IDColumn" type="xs:int" />
              <xs:element name="DOC_SUB_CAT_ID" msprop:Generator_UserColumnName="DOC_SUB_CAT_ID" msprop:Generator_ColumnPropNameInRow="DOC_SUB_CAT_ID" msprop:Generator_ColumnVarNameInTable="columnDOC_SUB_CAT_ID" msprop:Generator_ColumnPropNameInTable="DOC_SUB_CAT_IDColumn" type="xs:int" />
              <xs:element name="DOC" msprop:Generator_UserColumnName="DOC" msprop:Generator_ColumnPropNameInRow="DOC" msprop:Generator_ColumnVarNameInTable="columnDOC" msprop:Generator_ColumnPropNameInTable="DOCColumn" type="xs:base64Binary" />
              <xs:element name="DOC_TYPE" msprop:Generator_UserColumnName="DOC_TYPE" msprop:Generator_ColumnPropNameInRow="DOC_TYPE" msprop:Generator_ColumnVarNameInTable="columnDOC_TYPE" msprop:Generator_ColumnPropNameInTable="DOC_TYPEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_DATE" msprop:Generator_UserColumnName="DOC_DATE" msprop:Generator_ColumnPropNameInRow="DOC_DATE" msprop:Generator_ColumnVarNameInTable="columnDOC_DATE" msprop:Generator_ColumnPropNameInTable="DOC_DATEColumn" type="xs:dateTime" />
              <xs:element name="DOC_VERSION" msprop:Generator_UserColumnName="DOC_VERSION" msprop:Generator_ColumnPropNameInRow="DOC_VERSION" msprop:Generator_ColumnVarNameInTable="columnDOC_VERSION" msprop:Generator_ColumnPropNameInTable="DOC_VERSIONColumn" type="xs:decimal" />
              <xs:element name="DOC_NAME" msprop:Generator_UserColumnName="DOC_NAME" msprop:Generator_ColumnPropNameInRow="DOC_NAME" msprop:Generator_ColumnVarNameInTable="columnDOC_NAME" msprop:Generator_ColumnPropNameInTable="DOC_NAMEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_EXT" msprop:Generator_UserColumnName="DOC_EXT" msprop:Generator_ColumnPropNameInRow="DOC_EXT" msprop:Generator_ColumnVarNameInTable="columnDOC_EXT" msprop:Generator_ColumnPropNameInTable="DOC_EXTColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_AUTHOR" msprop:Generator_UserColumnName="DOC_AUTHOR" msprop:Generator_ColumnPropNameInRow="DOC_AUTHOR" msprop:Generator_ColumnVarNameInTable="columnDOC_AUTHOR" msprop:Generator_ColumnPropNameInTable="DOC_AUTHORColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="85" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_SUBJECT" msprop:Generator_UserColumnName="DOC_SUBJECT" msprop:Generator_ColumnPropNameInRow="DOC_SUBJECT" msprop:Generator_ColumnVarNameInTable="columnDOC_SUBJECT" msprop:Generator_ColumnPropNameInTable="DOC_SUBJECTColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_KEYWORDS" msprop:Generator_UserColumnName="DOC_KEYWORDS" msprop:Generator_ColumnPropNameInRow="DOC_KEYWORDS" msprop:Generator_ColumnVarNameInTable="columnDOC_KEYWORDS" msprop:Generator_ColumnPropNameInTable="DOC_KEYWORDSColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_TEXT" msprop:Generator_UserColumnName="DOC_TEXT" msprop:Generator_ColumnPropNameInRow="DOC_TEXT" msprop:Generator_ColumnVarNameInTable="columnDOC_TEXT" msprop:Generator_ColumnPropNameInTable="DOC_TEXTColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_INUSE" msprop:Generator_UserColumnName="DOC_INUSE" msprop:Generator_ColumnPropNameInRow="DOC_INUSE" msprop:Generator_ColumnVarNameInTable="columnDOC_INUSE" msprop:Generator_ColumnPropNameInTable="DOC_INUSEColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="DOC_USERID" msprop:Generator_UserColumnName="DOC_USERID" msprop:Generator_ColumnPropNameInRow="DOC_USERID" msprop:Generator_ColumnVarNameInTable="columnDOC_USERID" msprop:Generator_ColumnPropNameInTable="DOC_USERIDColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TBL_DOC_COMMENT" msprop:Generator_UserTableName="TBL_DOC_COMMENT" msprop:Generator_RowDeletedName="TBL_DOC_COMMENTRowDeleted" msprop:Generator_RowChangedName="TBL_DOC_COMMENTRowChanged" msprop:Generator_RowClassName="TBL_DOC_COMMENTRow" msprop:Generator_RowChangingName="TBL_DOC_COMMENTRowChanging" msprop:Generator_RowEvArgName="TBL_DOC_COMMENTRowChangeEvent" msprop:Generator_RowEvHandlerName="TBL_DOC_COMMENTRowChangeEventHandler" msprop:Generator_TableClassName="TBL_DOC_COMMENTDataTable" msprop:Generator_TableVarName="tableTBL_DOC_COMMENT" msprop:Generator_RowDeletingName="TBL_DOC_COMMENTRowDeleting" msprop:Generator_TablePropName="TBL_DOC_COMMENT">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="COMMENT_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="COMMENT_ID" msprop:Generator_ColumnPropNameInRow="COMMENT_ID" msprop:Generator_ColumnVarNameInTable="columnCOMMENT_ID" msprop:Generator_ColumnPropNameInTable="COMMENT_IDColumn" type="xs:int" />
              <xs:element name="COMMENT_DOC_ID" msprop:Generator_UserColumnName="COMMENT_DOC_ID" msprop:Generator_ColumnPropNameInRow="COMMENT_DOC_ID" msprop:Generator_ColumnVarNameInTable="columnCOMMENT_DOC_ID" msprop:Generator_ColumnPropNameInTable="COMMENT_DOC_IDColumn" type="xs:int" />
              <xs:element name="COMMENT_TITLE" msprop:Generator_UserColumnName="COMMENT_TITLE" msprop:Generator_ColumnPropNameInRow="COMMENT_TITLE" msprop:Generator_ColumnVarNameInTable="columnCOMMENT_TITLE" msprop:Generator_ColumnPropNameInTable="COMMENT_TITLEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="COMMENT_DESC" msprop:Generator_UserColumnName="COMMENT_DESC" msprop:Generator_ColumnPropNameInRow="COMMENT_DESC" msprop:Generator_ColumnVarNameInTable="columnCOMMENT_DESC" msprop:Generator_ColumnPropNameInTable="COMMENT_DESCColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="COMMENT_DATE" msprop:Generator_UserColumnName="COMMENT_DATE" msprop:Generator_ColumnPropNameInRow="COMMENT_DATE" msprop:Generator_ColumnVarNameInTable="columnCOMMENT_DATE" msprop:Generator_ColumnPropNameInTable="COMMENT_DATEColumn" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TBL_DOC_CAT" msprop:Generator_UserTableName="TBL_DOC_CAT" msprop:Generator_RowDeletedName="TBL_DOC_CATRowDeleted" msprop:Generator_RowChangedName="TBL_DOC_CATRowChanged" msprop:Generator_RowClassName="TBL_DOC_CATRow" msprop:Generator_RowChangingName="TBL_DOC_CATRowChanging" msprop:Generator_RowEvArgName="TBL_DOC_CATRowChangeEvent" msprop:Generator_RowEvHandlerName="TBL_DOC_CATRowChangeEventHandler" msprop:Generator_TableClassName="TBL_DOC_CATDataTable" msprop:Generator_TableVarName="tableTBL_DOC_CAT" msprop:Generator_RowDeletingName="TBL_DOC_CATRowDeleting" msprop:Generator_TablePropName="TBL_DOC_CAT">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DOC_CAT_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="DOC_CAT_ID" msprop:Generator_ColumnPropNameInRow="DOC_CAT_ID" msprop:Generator_ColumnVarNameInTable="columnDOC_CAT_ID" msprop:Generator_ColumnPropNameInTable="DOC_CAT_IDColumn" type="xs:int" />
              <xs:element name="DOC_CAT_TYPE" msprop:Generator_UserColumnName="DOC_CAT_TYPE" msprop:Generator_ColumnPropNameInRow="DOC_CAT_TYPE" msprop:Generator_ColumnVarNameInTable="columnDOC_CAT_TYPE" msprop:Generator_ColumnPropNameInTable="DOC_CAT_TYPEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_CAT_DESC" msprop:Generator_UserColumnName="DOC_CAT_DESC" msprop:Generator_ColumnPropNameInRow="DOC_CAT_DESC" msprop:Generator_ColumnVarNameInTable="columnDOC_CAT_DESC" msprop:Generator_ColumnPropNameInTable="DOC_CAT_DESCColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_CAT_ACTIVE" msprop:Generator_UserColumnName="DOC_CAT_ACTIVE" msprop:Generator_ColumnPropNameInRow="DOC_CAT_ACTIVE" msprop:Generator_ColumnVarNameInTable="columnDOC_CAT_ACTIVE" msprop:Generator_ColumnPropNameInTable="DOC_CAT_ACTIVEColumn" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TBL_ATTCH_DOC" msprop:Generator_UserTableName="TBL_ATTCH_DOC" msprop:Generator_RowDeletedName="TBL_ATTCH_DOCRowDeleted" msprop:Generator_RowChangedName="TBL_ATTCH_DOCRowChanged" msprop:Generator_RowClassName="TBL_ATTCH_DOCRow" msprop:Generator_RowChangingName="TBL_ATTCH_DOCRowChanging" msprop:Generator_RowEvArgName="TBL_ATTCH_DOCRowChangeEvent" msprop:Generator_RowEvHandlerName="TBL_ATTCH_DOCRowChangeEventHandler" msprop:Generator_TableClassName="TBL_ATTCH_DOCDataTable" msprop:Generator_TableVarName="tableTBL_ATTCH_DOC" msprop:Generator_RowDeletingName="TBL_ATTCH_DOCRowDeleting" msprop:Generator_TablePropName="TBL_ATTCH_DOC">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ATTCH_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ATTCH_ID" msprop:Generator_ColumnPropNameInRow="ATTCH_ID" msprop:Generator_ColumnVarNameInTable="columnATTCH_ID" msprop:Generator_ColumnPropNameInTable="ATTCH_IDColumn" type="xs:int" />
              <xs:element name="ATTCH_DOC_ID" msprop:Generator_UserColumnName="ATTCH_DOC_ID" msprop:Generator_ColumnPropNameInRow="ATTCH_DOC_ID" msprop:Generator_ColumnVarNameInTable="columnATTCH_DOC_ID" msprop:Generator_ColumnPropNameInTable="ATTCH_DOC_IDColumn" type="xs:int" />
              <xs:element name="ATTCH_REF_DOC_ID" msprop:Generator_UserColumnName="ATTCH_REF_DOC_ID" msprop:Generator_ColumnPropNameInRow="ATTCH_REF_DOC_ID" msprop:Generator_ColumnVarNameInTable="columnATTCH_REF_DOC_ID" msprop:Generator_ColumnPropNameInTable="ATTCH_REF_DOC_IDColumn" type="xs:int" />
              <xs:element name="ATTCH_NOTE" msprop:Generator_UserColumnName="ATTCH_NOTE" msprop:Generator_ColumnPropNameInRow="ATTCH_NOTE" msprop:Generator_ColumnVarNameInTable="columnATTCH_NOTE" msprop:Generator_ColumnPropNameInTable="ATTCH_NOTEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ATTCH_DATE" msprop:Generator_UserColumnName="ATTCH_DATE" msprop:Generator_ColumnPropNameInRow="ATTCH_DATE" msprop:Generator_ColumnVarNameInTable="columnATTCH_DATE" msprop:Generator_ColumnPropNameInTable="ATTCH_DATEColumn" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TBL_DOC_SUB_CAT" msprop:Generator_UserTableName="TBL_DOC_SUB_CAT" msprop:Generator_RowDeletedName="TBL_DOC_SUB_CATRowDeleted" msprop:Generator_RowChangedName="TBL_DOC_SUB_CATRowChanged" msprop:Generator_RowClassName="TBL_DOC_SUB_CATRow" msprop:Generator_RowChangingName="TBL_DOC_SUB_CATRowChanging" msprop:Generator_RowEvArgName="TBL_DOC_SUB_CATRowChangeEvent" msprop:Generator_RowEvHandlerName="TBL_DOC_SUB_CATRowChangeEventHandler" msprop:Generator_TableClassName="TBL_DOC_SUB_CATDataTable" msprop:Generator_TableVarName="tableTBL_DOC_SUB_CAT" msprop:Generator_RowDeletingName="TBL_DOC_SUB_CATRowDeleting" msprop:Generator_TablePropName="TBL_DOC_SUB_CAT">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DOC_SUB_CAT_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="DOC_SUB_CAT_ID" msprop:Generator_ColumnPropNameInRow="DOC_SUB_CAT_ID" msprop:Generator_ColumnVarNameInTable="columnDOC_SUB_CAT_ID" msprop:Generator_ColumnPropNameInTable="DOC_SUB_CAT_IDColumn" type="xs:int" />
              <xs:element name="DOC_CAT_ID" msprop:Generator_UserColumnName="DOC_CAT_ID" msprop:Generator_ColumnPropNameInRow="DOC_CAT_ID" msprop:Generator_ColumnVarNameInTable="columnDOC_CAT_ID" msprop:Generator_ColumnPropNameInTable="DOC_CAT_IDColumn" type="xs:int" />
              <xs:element name="DOC_SUB_CAT_TYPE" msprop:Generator_UserColumnName="DOC_SUB_CAT_TYPE" msprop:Generator_ColumnPropNameInRow="DOC_SUB_CAT_TYPE" msprop:Generator_ColumnVarNameInTable="columnDOC_SUB_CAT_TYPE" msprop:Generator_ColumnPropNameInTable="DOC_SUB_CAT_TYPEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_SUB_CAT_DESC" msprop:Generator_UserColumnName="DOC_SUB_CAT_DESC" msprop:Generator_ColumnPropNameInRow="DOC_SUB_CAT_DESC" msprop:Generator_ColumnVarNameInTable="columnDOC_SUB_CAT_DESC" msprop:Generator_ColumnPropNameInTable="DOC_SUB_CAT_DESCColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_SUB_CAT_ACTIVE" msprop:Generator_UserColumnName="DOC_SUB_CAT_ACTIVE" msprop:Generator_ColumnPropNameInRow="DOC_SUB_CAT_ACTIVE" msprop:Generator_ColumnVarNameInTable="columnDOC_SUB_CAT_ACTIVE" msprop:Generator_ColumnPropNameInTable="DOC_SUB_CAT_ACTIVEColumn" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="V_DOCUMENTS" msprop:Generator_UserTableName="V_DOCUMENTS" msprop:Generator_RowDeletedName="V_DOCUMENTSRowDeleted" msprop:Generator_RowChangedName="V_DOCUMENTSRowChanged" msprop:Generator_RowClassName="V_DOCUMENTSRow" msprop:Generator_RowChangingName="V_DOCUMENTSRowChanging" msprop:Generator_RowEvArgName="V_DOCUMENTSRowChangeEvent" msprop:Generator_RowEvHandlerName="V_DOCUMENTSRowChangeEventHandler" msprop:Generator_TableClassName="V_DOCUMENTSDataTable" msprop:Generator_TableVarName="tableV_DOCUMENTS" msprop:Generator_RowDeletingName="V_DOCUMENTSRowDeleting" msprop:Generator_TablePropName="V_DOCUMENTS">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DOC_ID" msprop:Generator_UserColumnName="DOC_ID" msprop:Generator_ColumnVarNameInTable="columnDOC_ID" msprop:Generator_ColumnPropNameInRow="DOC_ID" msprop:Generator_ColumnPropNameInTable="DOC_IDColumn" type="xs:int" />
              <xs:element name="DOC" msprop:Generator_UserColumnName="DOC" msprop:Generator_ColumnVarNameInTable="columnDOC" msprop:Generator_ColumnPropNameInRow="DOC" msprop:Generator_ColumnPropNameInTable="DOCColumn" type="xs:base64Binary" />
              <xs:element name="DOC_TYPE" msprop:Generator_UserColumnName="DOC_TYPE" msprop:Generator_ColumnVarNameInTable="columnDOC_TYPE" msprop:Generator_ColumnPropNameInRow="DOC_TYPE" msprop:Generator_ColumnPropNameInTable="DOC_TYPEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_DATE" msprop:Generator_UserColumnName="DOC_DATE" msprop:Generator_ColumnVarNameInTable="columnDOC_DATE" msprop:Generator_ColumnPropNameInRow="DOC_DATE" msprop:Generator_ColumnPropNameInTable="DOC_DATEColumn" type="xs:dateTime" />
              <xs:element name="DOC_VERSION" msprop:Generator_UserColumnName="DOC_VERSION" msprop:Generator_ColumnVarNameInTable="columnDOC_VERSION" msprop:Generator_ColumnPropNameInRow="DOC_VERSION" msprop:Generator_ColumnPropNameInTable="DOC_VERSIONColumn" type="xs:decimal" />
              <xs:element name="DOC_NAME" msprop:Generator_UserColumnName="DOC_NAME" msprop:Generator_ColumnVarNameInTable="columnDOC_NAME" msprop:Generator_ColumnPropNameInRow="DOC_NAME" msprop:Generator_ColumnPropNameInTable="DOC_NAMEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_EXT" msprop:Generator_UserColumnName="DOC_EXT" msprop:Generator_ColumnVarNameInTable="columnDOC_EXT" msprop:Generator_ColumnPropNameInRow="DOC_EXT" msprop:Generator_ColumnPropNameInTable="DOC_EXTColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_AUTHOR" msprop:Generator_UserColumnName="DOC_AUTHOR" msprop:Generator_ColumnVarNameInTable="columnDOC_AUTHOR" msprop:Generator_ColumnPropNameInRow="DOC_AUTHOR" msprop:Generator_ColumnPropNameInTable="DOC_AUTHORColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="85" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_SUBJECT" msprop:Generator_UserColumnName="DOC_SUBJECT" msprop:Generator_ColumnVarNameInTable="columnDOC_SUBJECT" msprop:Generator_ColumnPropNameInRow="DOC_SUBJECT" msprop:Generator_ColumnPropNameInTable="DOC_SUBJECTColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_KEYWORDS" msprop:Generator_UserColumnName="DOC_KEYWORDS" msprop:Generator_ColumnVarNameInTable="columnDOC_KEYWORDS" msprop:Generator_ColumnPropNameInRow="DOC_KEYWORDS" msprop:Generator_ColumnPropNameInTable="DOC_KEYWORDSColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_TEXT" msprop:Generator_UserColumnName="DOC_TEXT" msprop:Generator_ColumnVarNameInTable="columnDOC_TEXT" msprop:Generator_ColumnPropNameInRow="DOC_TEXT" msprop:Generator_ColumnPropNameInTable="DOC_TEXTColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_CAT_TYPE" msprop:Generator_UserColumnName="DOC_CAT_TYPE" msprop:Generator_ColumnVarNameInTable="columnDOC_CAT_TYPE" msprop:Generator_ColumnPropNameInRow="DOC_CAT_TYPE" msprop:Generator_ColumnPropNameInTable="DOC_CAT_TYPEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_CAT_DESC" msprop:Generator_UserColumnName="DOC_CAT_DESC" msprop:Generator_ColumnVarNameInTable="columnDOC_CAT_DESC" msprop:Generator_ColumnPropNameInRow="DOC_CAT_DESC" msprop:Generator_ColumnPropNameInTable="DOC_CAT_DESCColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_SUB_CAT_TYPE" msprop:Generator_UserColumnName="DOC_SUB_CAT_TYPE" msprop:Generator_ColumnVarNameInTable="columnDOC_SUB_CAT_TYPE" msprop:Generator_ColumnPropNameInRow="DOC_SUB_CAT_TYPE" msprop:Generator_ColumnPropNameInTable="DOC_SUB_CAT_TYPEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOC_CAT_ID" msprop:Generator_UserColumnName="DOC_CAT_ID" msprop:Generator_ColumnVarNameInTable="columnDOC_CAT_ID" msprop:Generator_ColumnPropNameInRow="DOC_CAT_ID" msprop:Generator_ColumnPropNameInTable="DOC_CAT_IDColumn" type="xs:int" />
              <xs:element name="DOC_SUB_CAT_ID" msprop:Generator_UserColumnName="DOC_SUB_CAT_ID" msprop:Generator_ColumnVarNameInTable="columnDOC_SUB_CAT_ID" msprop:Generator_ColumnPropNameInRow="DOC_SUB_CAT_ID" msprop:Generator_ColumnPropNameInTable="DOC_SUB_CAT_IDColumn" type="xs:int" />
              <xs:element name="DOC_INUSE" msprop:Generator_UserColumnName="DOC_INUSE" msprop:Generator_ColumnPropNameInRow="DOC_INUSE" msprop:Generator_ColumnVarNameInTable="columnDOC_INUSE" msprop:Generator_ColumnPropNameInTable="DOC_INUSEColumn" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TBL_ACCOUNT" msprop:Generator_UserTableName="TBL_ACCOUNT" msprop:Generator_RowDeletedName="TBL_ACCOUNTRowDeleted" msprop:Generator_RowChangedName="TBL_ACCOUNTRowChanged" msprop:Generator_RowClassName="TBL_ACCOUNTRow" msprop:Generator_RowChangingName="TBL_ACCOUNTRowChanging" msprop:Generator_RowEvArgName="TBL_ACCOUNTRowChangeEvent" msprop:Generator_RowEvHandlerName="TBL_ACCOUNTRowChangeEventHandler" msprop:Generator_TableClassName="TBL_ACCOUNTDataTable" msprop:Generator_TableVarName="tableTBL_ACCOUNT" msprop:Generator_RowDeletingName="TBL_ACCOUNTRowDeleting" msprop:Generator_TablePropName="TBL_ACCOUNT">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ACCT_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ACCT_ID" msprop:Generator_ColumnPropNameInRow="ACCT_ID" msprop:Generator_ColumnVarNameInTable="columnACCT_ID" msprop:Generator_ColumnPropNameInTable="ACCT_IDColumn" type="xs:int" />
              <xs:element name="ACCT_NAME" msprop:Generator_UserColumnName="ACCT_NAME" msprop:Generator_ColumnPropNameInRow="ACCT_NAME" msprop:Generator_ColumnVarNameInTable="columnACCT_NAME" msprop:Generator_ColumnPropNameInTable="ACCT_NAMEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCT_LASTNAME" msprop:Generator_UserColumnName="ACCT_LASTNAME" msprop:Generator_ColumnPropNameInRow="ACCT_LASTNAME" msprop:Generator_ColumnVarNameInTable="columnACCT_LASTNAME" msprop:Generator_ColumnPropNameInTable="ACCT_LASTNAMEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCT_ADD1" msprop:Generator_UserColumnName="ACCT_ADD1" msprop:Generator_ColumnPropNameInRow="ACCT_ADD1" msprop:Generator_ColumnVarNameInTable="columnACCT_ADD1" msprop:Generator_ColumnPropNameInTable="ACCT_ADD1Column">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="35" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCT_ADD2" msprop:Generator_UserColumnName="ACCT_ADD2" msprop:Generator_ColumnPropNameInRow="ACCT_ADD2" msprop:Generator_ColumnVarNameInTable="columnACCT_ADD2" msprop:Generator_ColumnPropNameInTable="ACCT_ADD2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="35" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCT_ADD3" msprop:Generator_UserColumnName="ACCT_ADD3" msprop:Generator_ColumnPropNameInRow="ACCT_ADD3" msprop:Generator_ColumnVarNameInTable="columnACCT_ADD3" msprop:Generator_ColumnPropNameInTable="ACCT_ADD3Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="35" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCT_CITY" msprop:Generator_UserColumnName="ACCT_CITY" msprop:Generator_ColumnPropNameInRow="ACCT_CITY" msprop:Generator_ColumnVarNameInTable="columnACCT_CITY" msprop:Generator_ColumnPropNameInTable="ACCT_CITYColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCT_STATE" msprop:Generator_UserColumnName="ACCT_STATE" msprop:Generator_ColumnPropNameInRow="ACCT_STATE" msprop:Generator_ColumnVarNameInTable="columnACCT_STATE" msprop:Generator_ColumnPropNameInTable="ACCT_STATEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCT_ZIPCODE" msprop:Generator_UserColumnName="ACCT_ZIPCODE" msprop:Generator_ColumnPropNameInRow="ACCT_ZIPCODE" msprop:Generator_ColumnVarNameInTable="columnACCT_ZIPCODE" msprop:Generator_ColumnPropNameInTable="ACCT_ZIPCODEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCT_ZIPCODE2" msprop:Generator_UserColumnName="ACCT_ZIPCODE2" msprop:Generator_ColumnPropNameInRow="ACCT_ZIPCODE2" msprop:Generator_ColumnVarNameInTable="columnACCT_ZIPCODE2" msprop:Generator_ColumnPropNameInTable="ACCT_ZIPCODE2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCT_PHY1" msprop:Generator_UserColumnName="ACCT_PHY1" msprop:Generator_ColumnPropNameInRow="ACCT_PHY1" msprop:Generator_ColumnVarNameInTable="columnACCT_PHY1" msprop:Generator_ColumnPropNameInTable="ACCT_PHY1Column">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="35" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCT_PHY2" msprop:Generator_UserColumnName="ACCT_PHY2" msprop:Generator_ColumnPropNameInRow="ACCT_PHY2" msprop:Generator_ColumnVarNameInTable="columnACCT_PHY2" msprop:Generator_ColumnPropNameInTable="ACCT_PHY2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="35" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCT_PHY3" msprop:Generator_UserColumnName="ACCT_PHY3" msprop:Generator_ColumnPropNameInRow="ACCT_PHY3" msprop:Generator_ColumnVarNameInTable="columnACCT_PHY3" msprop:Generator_ColumnPropNameInTable="ACCT_PHY3Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="35" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCT_PHYCITY" msprop:Generator_UserColumnName="ACCT_PHYCITY" msprop:Generator_ColumnPropNameInRow="ACCT_PHYCITY" msprop:Generator_ColumnVarNameInTable="columnACCT_PHYCITY" msprop:Generator_ColumnPropNameInTable="ACCT_PHYCITYColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCT_PHYSTATE" msprop:Generator_UserColumnName="ACCT_PHYSTATE" msprop:Generator_ColumnPropNameInRow="ACCT_PHYSTATE" msprop:Generator_ColumnVarNameInTable="columnACCT_PHYSTATE" msprop:Generator_ColumnPropNameInTable="ACCT_PHYSTATEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCT_PHYZIPCODE" msprop:Generator_UserColumnName="ACCT_PHYZIPCODE" msprop:Generator_ColumnPropNameInRow="ACCT_PHYZIPCODE" msprop:Generator_ColumnVarNameInTable="columnACCT_PHYZIPCODE" msprop:Generator_ColumnPropNameInTable="ACCT_PHYZIPCODEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCT_EMAIL" msprop:Generator_UserColumnName="ACCT_EMAIL" msprop:Generator_ColumnPropNameInRow="ACCT_EMAIL" msprop:Generator_ColumnVarNameInTable="columnACCT_EMAIL" msprop:Generator_ColumnPropNameInTable="ACCT_EMAILColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCT_USERNAME" msprop:Generator_UserColumnName="ACCT_USERNAME" msprop:Generator_ColumnPropNameInRow="ACCT_USERNAME" msprop:Generator_ColumnVarNameInTable="columnACCT_USERNAME" msprop:Generator_ColumnPropNameInTable="ACCT_USERNAMEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCT_PASSWORD" msprop:Generator_UserColumnName="ACCT_PASSWORD" msprop:Generator_ColumnPropNameInRow="ACCT_PASSWORD" msprop:Generator_ColumnVarNameInTable="columnACCT_PASSWORD" msprop:Generator_ColumnPropNameInTable="ACCT_PASSWORDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TBL_ZIPCODES" msprop:Generator_UserTableName="TBL_ZIPCODES" msprop:Generator_RowDeletedName="TBL_ZIPCODESRowDeleted" msprop:Generator_RowChangedName="TBL_ZIPCODESRowChanged" msprop:Generator_RowClassName="TBL_ZIPCODESRow" msprop:Generator_RowChangingName="TBL_ZIPCODESRowChanging" msprop:Generator_RowEvArgName="TBL_ZIPCODESRowChangeEvent" msprop:Generator_RowEvHandlerName="TBL_ZIPCODESRowChangeEventHandler" msprop:Generator_TableClassName="TBL_ZIPCODESDataTable" msprop:Generator_TableVarName="tableTBL_ZIPCODES" msprop:Generator_RowDeletingName="TBL_ZIPCODESRowDeleting" msprop:Generator_TablePropName="TBL_ZIPCODES">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ZIPCODEID" msprop:Generator_UserColumnName="ZIPCODEID" msprop:Generator_ColumnVarNameInTable="columnZIPCODEID" msprop:Generator_ColumnPropNameInRow="ZIPCODEID" msprop:Generator_ColumnPropNameInTable="ZIPCODEIDColumn" type="xs:int" />
              <xs:element name="ZIPCODE" msprop:Generator_UserColumnName="ZIPCODE" msprop:Generator_ColumnVarNameInTable="columnZIPCODE" msprop:Generator_ColumnPropNameInRow="ZIPCODE" msprop:Generator_ColumnPropNameInTable="ZIPCODEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CITY" msprop:Generator_UserColumnName="CITY" msprop:Generator_ColumnVarNameInTable="columnCITY" msprop:Generator_ColumnPropNameInRow="CITY" msprop:Generator_ColumnPropNameInTable="CITYColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="STATE" msprop:Generator_UserColumnName="STATE" msprop:Generator_ColumnVarNameInTable="columnSTATE" msprop:Generator_ColumnPropNameInRow="STATE" msprop:Generator_ColumnPropNameInTable="STATEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TBL_ACCTOUNT_SECURITY" msprop:Generator_UserTableName="TBL_ACCTOUNT_SECURITY" msprop:Generator_RowDeletedName="TBL_ACCTOUNT_SECURITYRowDeleted" msprop:Generator_RowChangedName="TBL_ACCTOUNT_SECURITYRowChanged" msprop:Generator_RowClassName="TBL_ACCTOUNT_SECURITYRow" msprop:Generator_RowChangingName="TBL_ACCTOUNT_SECURITYRowChanging" msprop:Generator_RowEvArgName="TBL_ACCTOUNT_SECURITYRowChangeEvent" msprop:Generator_RowEvHandlerName="TBL_ACCTOUNT_SECURITYRowChangeEventHandler" msprop:Generator_TableClassName="TBL_ACCTOUNT_SECURITYDataTable" msprop:Generator_TableVarName="tableTBL_ACCTOUNT_SECURITY" msprop:Generator_RowDeletingName="TBL_ACCTOUNT_SECURITYRowDeleting" msprop:Generator_TablePropName="TBL_ACCTOUNT_SECURITY">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ACC_PER_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ACC_PER_ID" msprop:Generator_ColumnPropNameInRow="ACC_PER_ID" msprop:Generator_ColumnVarNameInTable="columnACC_PER_ID" msprop:Generator_ColumnPropNameInTable="ACC_PER_IDColumn" type="xs:int" />
              <xs:element name="ACCT_ID" msprop:Generator_UserColumnName="ACCT_ID" msprop:Generator_ColumnPropNameInRow="ACCT_ID" msprop:Generator_ColumnVarNameInTable="columnACCT_ID" msprop:Generator_ColumnPropNameInTable="ACCT_IDColumn" type="xs:int" />
              <xs:element name="ACCT_LOAD" msprop:Generator_UserColumnName="ACCT_LOAD" msprop:Generator_ColumnPropNameInRow="ACCT_LOAD" msprop:Generator_ColumnVarNameInTable="columnACCT_LOAD" msprop:Generator_ColumnPropNameInTable="ACCT_LOADColumn" type="xs:boolean" />
              <xs:element name="ACCT_REANONLY" msprop:Generator_UserColumnName="ACCT_REANONLY" msprop:Generator_ColumnPropNameInRow="ACCT_REANONLY" msprop:Generator_ColumnVarNameInTable="columnACCT_REANONLY" msprop:Generator_ColumnPropNameInTable="ACCT_REANONLYColumn" type="xs:boolean" />
              <xs:element name="ACCT_DELETE" msprop:Generator_UserColumnName="ACCT_DELETE" msprop:Generator_ColumnPropNameInRow="ACCT_DELETE" msprop:Generator_ColumnVarNameInTable="columnACCT_DELETE" msprop:Generator_ColumnPropNameInTable="ACCT_DELETEColumn" type="xs:boolean" />
              <xs:element name="ACCT_COMMENT" msprop:Generator_UserColumnName="ACCT_COMMENT" msprop:Generator_ColumnPropNameInRow="ACCT_COMMENT" msprop:Generator_ColumnVarNameInTable="columnACCT_COMMENT" msprop:Generator_ColumnPropNameInTable="ACCT_COMMENTColumn" type="xs:boolean" />
              <xs:element name="ACCT_VERSION" msprop:Generator_UserColumnName="ACCT_VERSION" msprop:Generator_ColumnPropNameInRow="ACCT_VERSION" msprop:Generator_ColumnVarNameInTable="columnACCT_VERSION" msprop:Generator_ColumnPropNameInTable="ACCT_VERSIONColumn" type="xs:boolean" />
              <xs:element name="ACCT_CREATECOPY" msprop:Generator_UserColumnName="ACCT_CREATECOPY" msprop:Generator_ColumnPropNameInRow="ACCT_CREATECOPY" msprop:Generator_ColumnVarNameInTable="columnACCT_CREATECOPY" msprop:Generator_ColumnPropNameInTable="ACCT_CREATECOPYColumn" type="xs:boolean" />
              <xs:element name="ACCT_DUPLICATE" msprop:Generator_UserColumnName="ACCT_DUPLICATE" msprop:Generator_ColumnPropNameInRow="ACCT_DUPLICATE" msprop:Generator_ColumnVarNameInTable="columnACCT_DUPLICATE" msprop:Generator_ColumnPropNameInTable="ACCT_DUPLICATEColumn" type="xs:boolean" />
              <xs:element name="ACCT_DOC_SUB_CAT_ID" msprop:Generator_UserColumnName="ACCT_DOC_SUB_CAT_ID" msprop:Generator_ColumnPropNameInRow="ACCT_DOC_SUB_CAT_ID" msprop:Generator_ColumnVarNameInTable="columnACCT_DOC_SUB_CAT_ID" msprop:Generator_ColumnPropNameInTable="ACCT_DOC_SUB_CAT_IDColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TempList" />
      <xs:field xpath="mstns:DOC_ID" />
    </xs:unique>
    <xs:unique name="TBL_DOC_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TBL_DOC" />
      <xs:field xpath="mstns:DOC_ID" />
    </xs:unique>
    <xs:unique name="TBL_DOC_COMMENT_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TBL_DOC_COMMENT" />
      <xs:field xpath="mstns:COMMENT_ID" />
    </xs:unique>
    <xs:unique name="TBL_DOC_CAT_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TBL_DOC_CAT" />
      <xs:field xpath="mstns:DOC_CAT_ID" />
    </xs:unique>
    <xs:unique name="TBL_ATTCH_DOC_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TBL_ATTCH_DOC" />
      <xs:field xpath="mstns:ATTCH_ID" />
    </xs:unique>
    <xs:unique name="TBL_DOC_SUB_CAT_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TBL_DOC_SUB_CAT" />
      <xs:field xpath="mstns:DOC_SUB_CAT_ID" />
    </xs:unique>
    <xs:unique name="V_DOCUMENTS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:V_DOCUMENTS" />
      <xs:field xpath="mstns:DOC_ID" />
    </xs:unique>
    <xs:unique name="TBL_ACCOUNT_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TBL_ACCOUNT" />
      <xs:field xpath="mstns:ACCT_USERNAME" />
      <xs:field xpath="mstns:ACCT_PASSWORD" />
    </xs:unique>
    <xs:unique name="Constraint2">
      <xs:selector xpath=".//mstns:TBL_ACCOUNT" />
      <xs:field xpath="mstns:ACCT_ID" />
    </xs:unique>
    <xs:unique name="TBL_ZIPCODES_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TBL_ZIPCODES" />
      <xs:field xpath="mstns:ZIPCODEID" />
    </xs:unique>
    <xs:unique name="TBL_ACCTOUNT_SECURITY_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TBL_ACCTOUNT_SECURITY" />
      <xs:field xpath="mstns:ACC_PER_ID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_TBL_DOC_TBL_DOC_CAT" msdata:parent="TBL_DOC_CAT" msdata:child="TBL_DOC" msdata:parentkey="DOC_CAT_ID" msdata:childkey="DOC_CAT_ID" msprop:Generator_UserRelationName="FK_TBL_DOC_TBL_DOC_CAT" msprop:Generator_RelationVarName="relationFK_TBL_DOC_TBL_DOC_CAT" msprop:Generator_UserChildTable="TBL_DOC" msprop:Generator_UserParentTable="TBL_DOC_CAT" msprop:Generator_ParentPropName="TBL_DOC_CATRow" msprop:Generator_ChildPropName="GetTBL_DOCRows" />
      <msdata:Relationship name="FK_TBL_DOC_COMMENT_TBL_DOC" msdata:parent="TBL_DOC" msdata:child="TBL_DOC_COMMENT" msdata:parentkey="DOC_ID" msdata:childkey="COMMENT_DOC_ID" msprop:Generator_UserRelationName="FK_TBL_DOC_COMMENT_TBL_DOC" msprop:Generator_RelationVarName="relationFK_TBL_DOC_COMMENT_TBL_DOC" msprop:Generator_UserChildTable="TBL_DOC_COMMENT" msprop:Generator_UserParentTable="TBL_DOC" msprop:Generator_ParentPropName="TBL_DOCRow" msprop:Generator_ChildPropName="GetTBL_DOC_COMMENTRows" />
      <msdata:Relationship name="FK_TBL_DOC_TBL_DOC_SUB_CAT" msdata:parent="TBL_DOC_SUB_CAT" msdata:child="TBL_DOC" msdata:parentkey="DOC_SUB_CAT_ID" msdata:childkey="DOC_SUB_CAT_ID" msprop:Generator_UserRelationName="FK_TBL_DOC_TBL_DOC_SUB_CAT" msprop:Generator_RelationVarName="relationFK_TBL_DOC_TBL_DOC_SUB_CAT" msprop:Generator_UserChildTable="TBL_DOC" msprop:Generator_UserParentTable="TBL_DOC_SUB_CAT" msprop:Generator_ParentPropName="TBL_DOC_SUB_CATRow" msprop:Generator_ChildPropName="GetTBL_DOCRows" />
      <msdata:Relationship name="FK_TBL_DOC_SUB_CAT_TBL_DOC_CAT" msdata:parent="TBL_DOC_CAT" msdata:child="TBL_DOC_SUB_CAT" msdata:parentkey="DOC_CAT_ID" msdata:childkey="DOC_CAT_ID" msprop:Generator_UserRelationName="FK_TBL_DOC_SUB_CAT_TBL_DOC_CAT" msprop:Generator_RelationVarName="relationFK_TBL_DOC_SUB_CAT_TBL_DOC_CAT" msprop:Generator_UserChildTable="TBL_DOC_SUB_CAT" msprop:Generator_UserParentTable="TBL_DOC_CAT" msprop:Generator_ParentPropName="TBL_DOC_CATRow" msprop:Generator_ChildPropName="GetTBL_DOC_SUB_CATRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>